Search Results
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html
The next figure shows an example that adds table locks, uses replace instead of insert statements, quotes identifiers with backtick characters, and so on. Use this wizard to either export or import SQL generated from MySQL Workbench or with the ...
https://dev.mysql.com/doc/workbench/en/wb-admin-server-management.html
You can display only one administration tab at a time; subsequent administration tabs replace the active tab. Manage your MySQL instances with a comprehensive view of your MySQL server connections. The visual tree-based navigation provides detailed ...
https://dev.mysql.com/doc/workbench/en/wb-keys.html
The following tables list keyboard shortcuts for MySQL Workbench commands.
https://dev.mysql.com/doc/workbench/en/wb-migration-install-odbc-libraries.html
In the pyodbc source directory, edit the setup.py file and around line 157, replace the following line: settings['libraries'].append('odbc') with settings['libraries'].append('iodbc') Execute the following command as the root user: ... Note This ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-others.html
To set an alternative online service: URL location to display geometry point: [http://www.openstreetmap.org/?mlat=%LAT%&mlon=%LON%] Replace the default value with an alternative URL. The following figure shows the preference options that apply to ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-snippets.html
SQL DML (SQL Data Manipulation Language): Syntax examples for operations such as SELECT, INSERT, and REPLACE. The Snippets secondary tab includes built-in, local, and shared custom snippets. The My Snippets option stores custom snippets in a file ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-visual-explain-dbt3.html
SELECT * FROM orders WHERE o_orderdate BETWEEN '1992-04-01' AND '1992-04-30' AND o_clerk LIKE '%0223'; The updated query example results in a Visual Explain image in which Index Range Scan replaces the Full Table Scan generated by the last query ...
https://dev.mysql.com/doc/workbench/en/wb-views-physical-schemata.html
If it is already open, the selected table replaces the previous one. To add a view, double-clicking the Add View icon in the Physical Schemas section of the MySQL Model page. If a view with this name already exists, the new view is named view2.
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-62.html
The tabs were replaced by a list using a horizontal sidebar, and additional category names were added. This section summarizes many of the new features added to MySQL Workbench 6.2, in relation to the MySQL Workbench 6.1 release. Overlay Icons in ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-prepared-statements.html
Default Value true Since Version 3.1.12 useServerPrepStmts Use server-side prepared statements if the server supports them? The server may limit the number of prepared statements with 'max_prepared_stmt_count' or disable them altogether. In case of ...