User Tools

Site Tools


mysql_engines

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
mysql_engines [2017/03/07 10:33] – luke7858mysql_engines [2018/03/12 09:56] (current) – luke7858
Line 33: Line 33:
 === Find a Range of Tables with a Specific Engine === === Find a Range of Tables with a Specific Engine ===
 <sxh bash> <sxh bash>
-select engine, table_name from information_schema.tables where table_schema = 'magento' and table_name like '%xml%' and engine = InnoDB';+select engine, table_name from information_schema.tables where table_schema = 'magento' and table_name like '%xml%' and engine = 'InnoDB';
 </sxh> </sxh>
mysql_engines.1488882803.txt.gz · Last modified: (external edit)

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki