한국어

EDPS

MySQL 자체 메뉴얼

조회 수 1194 추천 수 0 2012.11.16 11:52:22

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


admin

2012.11.16 11:52:59
*.56.108.113

List of Articles
번호 제목 글쓴이 날짜 조회 수
199 MySQL - 3. MySQL 클라이언트 admin 2012-11-16 994
198 MySQL - 2. MySQL 클라이언트/서버 개념 admin 2012-11-16 1045
197 MySQL - 1. 공부할 내용 소개 admin 2012-11-16 1314
» MySQL 자체 메뉴얼 [1] admin 2012-11-16 1194
195 select [3] admin 2012-11-16 1182
194 오라클 퍼블릭클라우드, 유출된 전략 보니 WindBoy 2012-11-09 37417
193 오라클, 토탈아키텍처로 빅데이터 선점 WindBoy 2012-11-09 34328
192 오라클의 ‘빅데이터 어플라이언스’ WindBoy 2012-11-08 36425
191 ‘아파치 하둡’과 손 잡은 기업들 WindBoy 2012-11-08 35171
190 Selenium RC를 이용한 웹 애플리케이션 테스트 WindBoy 2012-11-05 39882
189 [품질관리] PMO와 프로젝트 감리: 물과 기름인가? WindBoy 2012-11-02 35778
188 [품질관리] CMM 수준 5에 대한 내부자의 견해 WindBoy 2012-11-02 47299
187 QA에 관한 생각 [1] WindBoy 2012-11-02 33996
186 빅데이터 플렛폼의 표준 - 하둡 [1] WindBoy 2012-11-02 34189
185 백신체커 및 유사 프로그램으로 고생한다면.... [1] WindBoy 2012-10-15 39761
184 펌] 숫자를 3자리씩 콤마(,)로 구분 [1] WindBoy 2012-10-10 35908
183 펌] html 과 flash간의 스크립트 호출방법 WindBoy 2012-10-10 28268
182 “클라우데라 개발 문화? 배우고 소통하죠” WindBoy 2012-09-18 31741
181 잘못 쓰는 우리 말, 어떤 것이 있을까? file WindBoy 2012-08-30 31170
180 DB 정규화 반정규화 WindBoy 2012-08-28 15655