PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/show-create-trigger.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. This statement requires the TRIGGER ...
https://dev.mysql.com/doc/refman/9.7/en/show-procedure-code.html
The second column is Instruction, which contains an SQL statement (usually changed from the original source), or a directive which has meaning only to the stored-routine handler. SHOW PROCEDURE CODE proc_name This statement is a MySQL extension ...
https://dev.mysql.com/doc/refman/9.7/en/show-tables.html
The optional FULL modifier causes SHOW TABLES to display a second output column with values of BASE TABLE for a table, VIEW for a view, or SYSTEM VIEW for an INFORMATION_SCHEMA table. SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name] [LIKE ...
https://dev.mysql.com/doc/refman/9.7/en/show-triggers.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers. SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default ...
https://dev.mysql.com/doc/refman/9.7/en/show-warnings.html
The second, because it is a SELECT statement is considered nondiagnostic and does clear the message list. SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the ...
https://dev.mysql.com/doc/refman/9.7/en/socket-pluggable-authentication.html
The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket file. The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program.
https://dev.mysql.com/doc/refman/9.7/en/sorted-index-builds.html
In the second phase, with one or more runs written to the temporary intermediate file, a merge sort is performed on all entries in the file. InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding ...
https://dev.mysql.com/doc/refman/9.7/en/source-configuration-options.html
Note Do not enable the WITH_TEST_TRACE_PLUGIN option if you want to use your own protocol trace plugins because only one such plugin can be loaded at a time and an error occurs for attempts to load a second one. The CMake program provides a great ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-geohash-functions.html
For the second syntax, a POINT value is required, where the X and Y coordinates are in the valid ranges for longitude and latitude, respectively. Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text ...
https://dev.mysql.com/doc/refman/9.7/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...