PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/signal.html
To signal a generic SQLSTATE value, use '45000', which means “unhandled user-defined exception.” The SIGNAL statement optionally includes a SET clause that contains multiple signal items, in a list of condition_information_item_name = ...Each ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-repuser.html
Although you do not have to create an account specifically for replication, you should be aware that the replication user name and password are stored in plain text in the replication metadata repositories (see Section 16.2.4.2, “Replication ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
You can set the size for individual tables as described later in this section. User-Created and Temporary Tables MEMORY table contents are stored in memory, which is a property that MEMORY tables share with internal temporary tables that the server ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
With user variables, the SET clause enables you to perform preprocessing transformations on their values before assigning the result to columns. User variables in the SET clause can be used in several ways. User variables cannot be used when loading ...By default, the server interprets the file contents using the character set indicated by the character_set_database system ...
https://dev.mysql.com/doc/refman/5.7/en/environment-variables.html
If this variable is set, its value overrides the default for $HOME/.mysql_history. USER The default user name on Windows when connecting to mysqld. For example, setting UMASK=0600 is equivalent to UMASK=384 because 0600 octal is 384 decimal. The ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. For example, the C API ...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/refman/5.7/en/show-create-user.html
row *************************** CREATE USER for root@localhost: CREATE USER 'root'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK The output ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
There is no user-facing mechanism for influencing this selection, which is completely automatic; the fact that it is automatic is a key part of NDB Cluster's internal architecture. For more information about MySQL Cluster Manager, see MySQL Cluster ...How do I handle MySQL users in an NDB Cluster having multiple MySQL servers? ...In the event of a catastrophic failure— for ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-actors-table.html
For each new foreground thread, the Performance Schema matches the user and host for the thread against the rows of the setup_actors table. The setup_actors table contains information that determines whether to enable monitoring and historical ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
If a ROW_FORMAT option is not defined explicitly in the table definition or ROW_FORMAT=DEFAULT is used, the innodb_default_row_format setting must be the same on the source and destination instances. A convenient way to accomplish this is to add ...