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

Next revision		Previous revision
wamp:mysql:sql_statements [2016/02/12 07:38] – created 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 8: Line 8:
 of a column). Here are the main actions that are possible: of a column). Here are the main actions that are possible:
      
 +** ADD [COLUMN] create_definition [FIRST | AFTER column_name] **
 +
 +**  ADD INDEX [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.1455262727.txt.gz · Last modified: 2016/02/12 07:38 (external edit)