docs:mysql:alter_table

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
docs:mysql:alter_table [2007/03/24 22:40] – billhdocs:mysql:alter_table [2008/08/03 00:25] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ====== ALTER TABLE ====== ====== ALTER TABLE ======
   * http://dev.mysql.com/doc/refman/4.1/en/alter-table.html   * http://dev.mysql.com/doc/refman/4.1/en/alter-table.html
 +
 +===== Standard Syntax =====
 +<code sql>
 +ALTER TABLE tablename
 +(
 +  ADD|DROP  column  datatype  [NULL|NOT NULL]  [CONSTRAINTS],
 +  ADD|DROP  column  datatype  [NULL|NOT NULL]  [CONSTRAINTS],
 +  ...
 +);
 +</code>
  
 ===== Adding a Primary Key ===== ===== Adding a Primary Key =====
Line 13: Line 23:
   * alter table mytable CONVERT TO CHARACTER SET latin1 [COLLATE collation_name];   * alter table mytable CONVERT TO CHARACTER SET latin1 [COLLATE collation_name];
  
 +===== Converting to a different engine =====
 +  * alter table mytable type = INNODB;
 +  * alter table mytable type = MYISAM;
 +
 +===== Renaming a Column =====
 +  * alter table weeks change status_id status_type_id int(2) not null;
 +    * table name: weeks
 +    * old column name: status_id
 +    * new column name: status_type_id
  • docs/mysql/alter_table.1174797631.txt.gz
  • Last modified: 2008/08/03 00:25
  • (external edit)