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
|
운영자 : 김두형(www.sunmysql.co.kr)
email : beansoft@nate.com
업데이트 : 20081015
