The Book

User Tools

Site Tools

Trace:
wamp:mysql:sql_statements

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
wamp:mysql:sql_statements [2016/02/12 07:41] – rpleckowamp:mysql:sql_statements [2016/02/12 07:51] (current) – external edit 127.0.0.1
Line 1: Line 1:
-====SQL Statements Implemented in MySQL====+=====SQL Statements Implemented in MySQL=====
  
-===Alter Table===+====Alter Table====
   ALTER [IGNORE] TABLE tbl_name action[, action …]   ALTER [IGNORE] TABLE tbl_name action[, action …]
 In this code, action refers to an action as defined below. In this code, action refers to an action as defined below.
Line 13: Line 13:
  
 **  ADD FULLTEXT [index_name] (index_col_name, …)** **  ADD FULLTEXT [index_name] (index_col_name, …)**
 +
 +**ADD PRIMARY KEY (index_col_name, …)**
 +
 +**ADD UNIQUE [index_name] (index_col_name, …)**
 +
 +**ALTER [COLUMN] col_name {SET DEFAULT value | DROP DEFAULT}**
 +
 +**CHANGE [COLUMN] col_name create_definition**
 +
 +**DISABLE KEYS / ENABLE KEYS**
 +
 +**DROP [COLUMN] col_name**
 +
 +**DROP PRIMARY KEY / DROP INDEX index_name**
 +
 +**MODIFY [COLUMN] create_definition**
 +
 +**ORDER BY col_name**
 +
 +**RENAME [TO] new_tbl_name**
 +
 +**table_options**
 +
 +====Analyze table====
 +
 +**ANALYZE TABLE tbl_name[, tbl_name, …]**
 +
 +
 +
wamp/mysql/sql_statements.1455262891.txt.gz · Last modified: 2016/02/12 07:41 (external edit)