MySQL 자체 메뉴얼 활용하기

mysql> help

Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 9 Server version: 5.0.68-enterprise-log MySQL Enterprise Server (Commercial) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> help For information about MySQL products and services, visit:    http://www.mysql.com/ For developer information, including the MySQL Reference Manual, visit:    http://dev.mysql.com/ To buy MySQL Network Support, training, or other products, visit:    https://shop.mysql.com/ List of all MySQL commands: Note that all text commands must be first on line and end with ';' ?         (\?) Synonym for `help'. clear     (\c) Clear command. connect   (\r) Reconnect to the server. Optional arguments are db and host. delimiter (\d) Set statement delimiter. NOTE: Takes the rest of the line as new delimiter. edit      (\e) Edit command with $EDITOR. ego       (\G) Send command to mysql server, display result vertically. exit      (\q) Exit mysql. Same as quit. go        (\g) Send command to mysql server. help      (\h) Display this help. nopager   (\n) Disable pager, print to stdout. notee     (\t) Don't write into outfile. pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER. print     (\p) Print current command. prompt    (\R) Change your mysql prompt. quit      (\q) Quit mysql. rehash    (\#) Rebuild completion hash. source    (\.) Execute an SQL script file. Takes a file name as an argument. status    (\s) Get status information from the server. system    (\!) Execute a system shell command. tee       (\T) Set outfile [to_outfile]. Append everything into given outfile. use       (\u) Use another database. Takes database name as argument. charset   (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets. warnings  (\W) Show warnings after every statement. nowarning (\w) Don't show warnings after every statement. For server side help, type 'help contents'

 

mysql> help contents

mysql> help contents You asked for help about help category: "Contents" For more information, type 'help <item>', where <item> is one of the following categories:    Account Management    Administration    Data Definition    Data Manipulation    Data Types    Functions    Functions and Modifiers for Use with GROUP BY    Geographic Features    Language Structure    Storage Engines    Stored Routines    Table Maintenance    Transactions    Triggers    User-Defined Functions    Utility

 

mysql> help Account Management

mysql> help Account Management You asked for help about help category: "Account Management" For more information, type 'help <item>', where <item> is one of the following topics:    CREATE USER    DROP USER    GRANT    RENAME USER    REVOKE    SET PASSWORD

 

mysql> help Administration

mysql> help Administration You asked for help about help category: "Administration" For more information, type 'help <item>', where <item> is one of the following topics:    FLUSH QUERY CACHE    HELP COMMAND

 

mysql> help Data Definition

mysql> help Data Definition You asked for help about help category: "Data Definition" For more information, type 'help <item>', where <item> is one of the following topics:    ALTER DATABASE    ALTER TABLE    ALTER VIEW    CONSTRAINT    CREATE DATABASE    CREATE INDEX    CREATE TABLE    CREATE VIEW    DROP DATABASE    DROP INDEX    DROP TABLE    DROP VIEW    MERGE    RENAME TABLE

 

mysql> help Data Manipulation

mysql> help Data Manipulation You asked for help about help category: "Data Manipulation" For more information, type 'help <item>', where <item> is one of the following topics:    CACHE INDEX    CHANGE MASTER TO    DEALLOCATE PREPARE    DELETE    DO    DUAL    EXECUTE STATEMENT    FLUSH    HANDLER    INSERT    INSERT DELAYED    INSERT SELECT    JOIN    KILL    LOAD DATA    LOAD DATA FROM MASTER    LOAD INDEX    LOAD TABLE FROM MASTER    PREPARE    PURGE MASTER LOGS    REPLACE INTO    RESET    RESET MASTER    RESET SLAVE    SELECT    SET    SET GLOBAL SQL_SLAVE_SKIP_COUNTER    SET SQL_LOG_BIN    SHOW    SHOW BINARY LOGS    SHOW BINLOG EVENTS    SHOW CHARACTER SET    SHOW COLLATION    SHOW COLUMNS    SHOW CREATE DATABASE    SHOW CREATE PROCEDURE    SHOW CREATE TABLE    SHOW CREATE VIEW    SHOW DATABASES    SHOW ENGINE    SHOW ENGINES    SHOW ERRORS    SHOW GRANTS    SHOW INDEX    SHOW INNODB STATUS    SHOW LOGS    SHOW MASTER STATUS    SHOW MUTEX STATUS    SHOW OPEN TABLES    SHOW PRIVILEGES    SHOW PROCEDURE CODE    SHOW PROCEDURE STATUS    SHOW PROCESSLIST    SHOW PROFILES    SHOW SLAVE HOSTS    SHOW SLAVE STATUS    SHOW STATUS    SHOW TABLE STATUS    SHOW TABLES    SHOW TRIGGERS    SHOW VARIABLES    SHOW WARNINGS    START SLAVE    STOP SLAVE    TRUNCATE TABLE    UNION    UPDATE

 

mysql> help Data Types

mysql> help Data Types You asked for help about help category: "Data Types" For more information, type 'help <item>', where <item> is one of the following topics:    AUTO_INCREMENT    BIGINT    BINARY    BIT    BLOB    BLOB DATA TYPE    BOOLEAN    CHAR    CHAR BYTE    DATE    DATETIME    DEC    DECIMAL    DOUBLE    DOUBLE PRECISION    ENUM    FLOAT    INT    INTEGER    LONGBLOB    LONGTEXT    MEDIUMBLOB    MEDIUMINT    MEDIUMTEXT    SET DATA TYPE    SMALLINT    TEXT    TIME    TIMESTAMP    TINYBLOB    TINYINT    TINYTEXT    VARBINARY    VARCHAR    YEAR DATA TYPE

 

mysql> help Functions

mysql> help Functions You asked for help about help category: "Functions" For more information, type 'help <item>', where <item> is one of the following topics:    PROCEDURE ANALYSE categories:    Bit Functions    Comparison operators    Control flow functions    Date and Time Functions    Encryption Functions    Information Functions    Logical operators    Miscellaneous Functions    Numeric Functions    String Functions

 

mysql> help Functions and Modifiers for Use with GROUP BY

mysql> help Functions and Modifiers for Use with GROUP BY You asked for help about help category: "Functions and Modifiers for Use with GROUP BY" For more information, type 'help <item>', where <item> is one of the following topics:    AVG    BIT_AND    BIT_OR    BIT_XOR    COUNT    COUNT DISTINCT    GROUP_CONCAT    MAX    MIN    STD    STDDEV    STDDEV_POP    STDDEV_SAMP    SUM    VARIANCE    VAR_POP    VAR_SAMP

 

mysql> help Geographic Features

mysql> help Geographic Features You asked for help about help category: "Geographic Features" For more information, type 'help <item>', where <item> is one of the following topics:    GEOMETRY    GEOMETRY HIERARCHY    SPATIAL categories:    Geometry constructors    Geometry properties    Geometry relations    LineString properties    MBR    Point properties    Polygon properties    WKB    WKT

 

mysql> help Language Structure

mysql> help Language Structure Name: 'Language Structure' Description: TRUE FALSEExamples: N

 

mysql> help Storage Engines 혹은 mysql> help engines

mysql> help Storage Engines Nothing found Please try to run 'help contents' for a list of all accessible topics   혹은   mysql> help engines Many help items for your request exist. To make a more specific request, please type 'help <item>', where <item> is one of the following topics:    SHOW    SHOW ENGINES

 

mysql> help Stored Routines

mysql> help Stored Routines You asked for help about help category: "Stored Routines" For more information, type 'help <item>', where <item> is one of the following topics:    ALTER PROCEDURE    BEGIN END    CALL    CASE STATEMENT    CLOSE    CREATE FUNCTION    CREATE PROCEDURE    DECLARE CONDITION    DECLARE CURSOR    DECLARE HANDLER    DECLARE VARIABLE    DROP FUNCTION    DROP PROCEDURE    FETCH    IF STATEMENT    ITERATE    LEAVE    LOOP    OPEN    REPEAT LOOP    RETURN    SELECT INTO    SET VARIABLE    WHILE

 

mysql> help Table Maintenance

mysql> help Table Maintenance You asked for help about help category: "Table Maintenance" For more information, type 'help <item>', where <item> is one of the following topics:    ANALYZE TABLE    BACKUP TABLE    CHECK TABLE    CHECKSUM TABLE    OPTIMIZE TABLE    REPAIR TABLE    RESTORE TABLE

 

mysql> help Transactions

mysql> help Transactions You asked for help about help category: "Transactions" For more information, type 'help <item>', where <item> is one of the following topics:    ISOLATION    LOCK    SAVEPOINT    START TRANSACTION

 

mysql> help Triggers

mysql> help Triggers Name: 'SHOW TRIGGERS' Description: Syntax: SHOW TRIGGERS [FROM db_name]     [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). This statement requires the SUPER privilege. It was implemented in MySQL 5.0.10. The LIKE clause, if present, indicates which table names to match and causes the statement to display triggers for those tables. The WHERE clause can be given to select rows using more general conditions, as discussed in http://dev.mysql.com/doc/refman/5.0/en/extended-show.html. For the trigger ins_sum as defined in http://dev.mysql.com/doc/refman/5.0/en/using-triggers.html, the output of this statement is as shown here: mysql> SHOW TRIGGERS LIKE 'acc%'\G *************************** 1. row ***************************   Trigger: ins_sum     Event: INSERT     Table: account Statement: SET @sum = @sum + NEW.amount    Timing: BEFORE   Created: NULL  sql_mode:   Definer: myname@localhost URL: http://dev.mysql.com/doc/refman/5.0/en/show-triggers.html

 

mysql> help User-Defined Functions

mysql> help User-Defined Functions You asked for help about help category: "User-Defined Functions" For more information, type 'help <item>', where <item> is one of the following topics:    CREATE FUNCTION UDF    DROP FUNCTION UDF

 

mysql> help Utility

mysql> help Utility You asked for help about help category: "Utility" For more information, type 'help <item>', where <item> is one of the following topics:    DESCRIBE    EXPLAIN    HELP STATEMENT    USE