wamp:mysql:sql_statements
This is an old revision of the document!
SQL Statements Implemented in MySQL
Alter Table
ALTER [IGNORE] TABLE tbl_name action[, action …]
In this code, action refers to an action as defined below. ALTER TABLE queries may be used to change the definition of a table without losing any of the information in that table (except in obvious cases, such as the deletion 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, …)
wamp/mysql/sql_statements.1455262813.txt.gz · Last modified: 2016/02/12 07:40 (external edit)