PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/document-store-concepts.html
Relational tables on the other hand require that their structure be defined, and all rows in the table must contain the same columns. This section explains the concepts introduced as part of using MySQL as a document store. JSON Document Collection ...
https://dev.mysql.com/doc/refman/8.0/en/drop-server.html
DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/8.0/en/drop-user.html
It removes privilege rows for the account from all grant tables. The DROP USER statement removes one or more MySQL accounts and their privileges. Roles named in the mandatory_roles system variable value cannot be dropped. To use DROP USER, you must ...
https://dev.mysql.com/doc/refman/8.0/en/error-lost-connection.html
Sometime you may see an ER_NET_PACKET_TOO_LARGE error, and that confirms that you need to increase max_allowed_packet. Sometimes the “during query” form happens when millions of rows are being sent as part of one or more queries. If the cause is ...Usually it indicates network connectivity trouble and you should check the condition of your network if this error occurs ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-elements.html
This section discusses how error messages originate within MySQL and the elements they contain. The MySQL server writes some error messages to its error log. These indicate issues of interest to database administrators or that require DBA action.
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
For example, you could use the GET_LOCK() function, or row or table locking. MySQL Events are tasks that run according to a schedule. When you create an event, you are creating a named database object containing one or more SQL statements to be ...
https://dev.mysql.com/doc/refman/8.0/en/example-storage-engine.html
mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 (HY000): Table storage engine for 'test' doesn't » have this option mysql> SELECT * FROM test; Empty set ... The EXAMPLE storage engine is a stub engine that does ...
https://dev.mysql.com/doc/refman/8.0/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-server.html
The CREATE SERVER statement updates the rows in the mysql.servers table. If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
When device registration has been performed for the account, the server updates the mysql.user system table row for that account to update the device registration status and to store the public key and credential ID. Note FIDO pluggable ...