Skip to content

Instantly share code, notes, and snippets.

@zs1621

zs1621/change_table_engine.mysql

Created January 16, 2014 13:12
Show Gist options
  • Save zs1621/8454795 to your computer and use it in GitHub Desktop.
Save zs1621/8454795 to your computer and use it in GitHub Desktop.
Download ZIP
改变mysql表的engine
Raw
change_table_engine.mysql
use test
CREATE TABLE CheckInCopy LIKE CheckIn;
ALTER TABLE CheckInCopy ENGINE=MyISAM;
INSERT INTO CheckInCopy SELECT * FROM CheckIn;
DROP TABLE IF EXISTS `CheckIn`;
rename table CheckInCopy to CheckIn;
show create table CheckIn;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment