×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Jing Tai Piao
Added: Aug 11, 2013 10:36 AM
Views: 1832
Tags: no tags
  1. CREATE TABLE innodb_table LIKE myisam_table;
  2.  
  3. ALTER TABLE innodb_table engine= innodb;
  4. INSERT INTO innodb_table SELECT * FROM myisam_table;