PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-destination-configuration.html
This is true even for sinks such as log_sink_json that can be enabled multiple times; all instances write to the console. This section describes which server options configure the default error log destination, which can be the console or a named ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-event-fields.html
Core Error Event Fields Optional Error Event Fields Core Error Event Fields These error event fields are core fields: time The event timestamp, with microsecond precision. Error events intended for the error log contain a set of fields, each of ...
https://dev.mysql.com/doc/refman/8.0/en/error-log.html
The error log contains a record of mysqld startup and shutdown times. This section discusses how to configure the MySQL server for logging of diagnostic messages to the error log. For information about selecting the error message character set and ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
You can view current values for all of these at one time by running the statement SHOW STATUS LIKE '%event%';. To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable.
https://dev.mysql.com/doc/refman/8.0/en/execute.html
You can execute a given prepared statement multiple times, passing different variables to it or setting the variables to different values before each execution. EXECUTE stmt_name [USING @var_name [, @var_name] ...] After preparing a statement with ...
https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html
Pass the CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS flag to mysql_real_connect() at connect time: MYSQL mysql; mysql_init(&mysql); if (!mysql_real_connect(&mysql, host, user, password, db, port, unix_socket, CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS)) { ...
https://dev.mysql.com/doc/refman/8.0/en/explain-for-connection.html
For example, if you are running a statement in one session that is taking a long time to complete, using EXPLAIN FOR CONNECTION in another session may yield useful information about the cause of the delay. To obtain the execution plan for an ...
https://dev.mysql.com/doc/refman/8.0/en/external-locking.html
If the server is run with external locking enabled, you can use myisamchk at any time for read operations such a checking tables. External locking affects server performance because the server must sometimes wait for other processes before it can ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html
Does MySQL have a NOW() function with fractions of seconds? Yes, see Section 13.2.6, “Fractional Seconds in Time Values”. Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? A.1.3. Does MySQL have a NOW() function with ...