Differences

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

--- wamp:mysql:sql_statements [2016/02/12 07:40] – rplecko
+++ wamp: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 …]
 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:
-  **ADD [COLUMN] create_definition [FIRST | AFTER column_name]**
+** 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, …]**
-  ADD INDEX [index_name] (index_col_name, …)
-  ADD FULLTEXT [index_name] (index_col_name, …)