PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/server-shutdown.html
For example, a user with the SHUTDOWN privilege can execute a mysqladmin shutdown command. The server shutdown process takes place as follows: The shutdown process is initiated. Other operating system-specific shutdown initiation methods are ...
https://dev.mysql.com/doc/refman/5.7/en/server-side-help-support.html
Change location into that directory and process the file with the mysql client as follows: mysql -u root -p mysql < fill_help_tables.sql The command shown here assumes that you connect to the server using an account such as root that has privileges ... MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 13.8.3, “HELP ...
https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html
The statement is not permitted within transactions: mysql> START TRANSACTION; Query OK, 0 rows affected (0.02 sec) mysql> SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; ERROR 1568 (25001): Transaction characteristics can't be changed while a ...
https://dev.mysql.com/doc/refman/5.7/en/show-binary-logs.html
A user with the SUPER or REPLICATION CLIENT privilege may execute this statement. SHOW BINARY LOGS SHOW MASTER LOGS Lists the binary log files on the server. This statement is used as part of the procedure described in Section 13.4.1.1, “PURGE ...
https://dev.mysql.com/doc/refman/5.7/en/show-binlog-events.html
SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary log. If you do not specify 'log_name', the first binary log is displayed. The LIMIT clause has the same syntax as for the SELECT statement.
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
It requires the EVENT privilege for the database from which the event is to be shown. SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. For example (using the same event e_daily ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html
If you do not have privileges for the routine itself, the value displayed for the Create Procedure or Create Function column is NULL. SHOW CREATE PROCEDURE proc_name This statement is a MySQL extension. It returns the exact string that can be used ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-table.html
To use this statement, you must have some privilege for the table. SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named table. row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int(11) NOT ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.html
This statement requires the TRIGGER privilege for the table associated with the trigger. SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. row *************************** Trigger: ...
https://dev.mysql.com/doc/refman/5.7/en/show-engine.html
SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage engine. The statement has these variants: SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX SHOW ENGINE PERFORMANCE_SCHEMA STATUS SHOW ENGINE ...