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/09/05 21:46] – billhdocs:mysql:alter_table [2008/08/03 00:25] (current) – external edit 127.0.0.1
Line 22: Line 22:
   * alter table mytable CONVERT TO CHARACTER SET latin1;   * alter table mytable CONVERT TO CHARACTER SET latin1;
   * 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 ===== ===== Renaming a Column =====
  • docs/mysql/alter_table.1189050408.txt.gz
  • Last modified: 2008/08/03 00:25
  • (external edit)