Search Results
https://dev.mysql.com/doc/refman/8.4/en/connecting-disconnecting.html
To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. Once you know the proper parameters, you should be able to connect like this: $> mysql -h host -u user -p Enter password: ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-example.html
If client A attempts to update a row in Birds at the same time, this will lead to a deadlock: mysql> UPDATE Birds SET value=40 WHERE name='Buzzard'; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction InnoDB rolls ... The following example illustrates how an error can occur when a lock request causes a ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
lock_type: { READ [LOCAL] | WRITE } UNLOCK {TABLE | TABLES} MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating with other sessions for access to tables, or to prevent other sessions from modifying tables ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
In the WHERE expression, you can use any of the functions and operators that MySQL supports, except for aggregate (group) functions. MySQL does not require FROM DUAL if no tables are referenced. The preceding example could have been written like ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Other language interfaces can provide support for prepared statements that use the binary protocol by linking in the C client library, one example being the mysqli extension, available in PHP 5.0 and later. You can use it from any program that can ...Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-table-update.html
Rename the original mysql.backup_progress table to mysql.backup_progress_old, and the mysql.backup_progress_new table to mysql.backup_progress. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
Table 5.1 Connector/ODBC DSN Configuration Options Parameter GUI Option Default Value Comment user User ODBC The user name used to connect to MySQL. server TCP/IP Server localhost The host name of the MySQL server. - Added in 8.0.31 rsakey RSA ...On ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html
Table 5.1 Connector/ODBC DSN Configuration Options Parameter GUI Option Default Value Comment user User ODBC The user name used to connect to MySQL. server TCP/IP Server localhost The host name of the MySQL server. - Added in 8.0.31 rsakey RSA ...On ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-auto-parallel-load.html
Auto Parallel Load is a feature of MySQL HeatWave that automates many of the steps for loading data, which include the following: Excluding schemas, tables, and columns that cannot be loaded. Requirements and Privileges for Auto Parallel Load To ...