Differences

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

--- wamp:mysql:sql_statements [2016/02/12 07:46] – 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 26: / Line 26: @@
 **DROP [COLUMN] col_name**
-**DROP PRIMARY KEY**
+**DROP PRIMARY KEY / DROP INDEX index_name**
-**DROP INDEX index_name**
 **MODIFY [COLUMN] create_definition**
-ORDER BY col_name
+**ORDER BY col_name**
-RENAME [TO] new_tbl_name
+**RENAME [TO] new_tbl_name**
-table_options
+**table_options**
+====Analyze table====
+**ANALYZE TABLE tbl_name[, tbl_name, …]**