MySQL: Difference between revisions
Jump to navigation
Jump to search
Anthoanthop (talk | contribs) No edit summary |
Anthoanthop (talk | contribs) No edit summary |
||
| Line 4: | Line 4: | ||
SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'MYDB' AND ENGINE IS NOT NULL ORDER BY ENGINE; | SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'MYDB' AND ENGINE IS NOT NULL ORDER BY ENGINE; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
* Change engine for a MYTABLE table: | * Change engine for a MYTABLE table: | ||
<syntaxhighlight lang="sql">ALTER TABLE MYTABLE ENGINE=InnoDB; | <syntaxhighlight lang="sql">ALTER TABLE MYTABLE ENGINE=InnoDB; | ||
ALTER TABLE MYTABLE ENGINE=MyISAM;</syntaxhighlight> | |||
Revision as of 10:53, 16 April 2015
- List MySQL tables engines for a MYDB database:
SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'MYDB' AND ENGINE IS NOT NULL ORDER BY ENGINE;
- Change engine for a MYTABLE table:
ALTER TABLE MYTABLE ENGINE=InnoDB;
ALTER TABLE MYTABLE ENGINE=MyISAM;