Search Results
https://dev.mysql.com/doc/workbench/en/wb-model-overview-privileges.html
The following figure shows the film table object from the sakila schema with INDEX, INSERT, SELECT, and TRIGGER selected for the role1 role. The Schema Privileges panel has the following sections, used to create users for your schemas and to define ...
https://dev.mysql.com/doc/workbench/en/wb-performance-dashboard.html
Data points include the Table Open Cache efficiency, SQL Statements Executed, and counts (per second) for SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP statements. To display the dashboard, open a query tab and then click Dashboard from ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
Use UPPERCASE keywords on completion Normally keywords are shown and inserted as they come from the code editor's configuration file. This section provides configuration options that affect the SQL editor functionality in MySQL Workbench. Permits ...
https://dev.mysql.com/doc/workbench/en/wb-routines.html
The privileges that display are: ALL CREATE DROP GRANT OPTION REFERENCES ALTER DELETE INDEX INSERT SELECT UPDATE TRIGGER You can choose to assign all privileges to a specific role or any other privilege as listed previously. 9.1.6.1.1 Adding ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-query-panel.html
The item name will be inserted into the SQL Query panel. The SQL query secondary tab opens by default when you make a connection to a server from the Home screen. You can enter SQL statements directly into the query editor area. The statements ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-options-tab.html
You may specify the action the server should take when users attempt to perform INSERT statements on the merge table. The Options subtab enables you to set several types of options. Figure 8.19 The Options Tab Table options are grouped into the ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
New and changed keywords: ARRAY FAILED_LOGIN_ATTEMPTS MASTER_COMPRESSION_ALGORITHM MASTER_TLS_CIPHERSUITES MASTER_ZSTD_COMPRESSION_LEVEL MEMBER OFF PASSWORD_LOCK_TIME PRIVILEGE_CHECKS_USER RANDOM REQUIRE_ROW_FORMAT REQUIRE_TABLE_PRIMARY_KEY_CHECK ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-connection.html
"affected rows" for DML statements, but does cause correct update counts from "INSERT ... connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL ...
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 ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-result-sets.html
clobberStreamingResults This will cause a streaming result set to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.