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
Next revision
Previous revision
mysql_engines [2017/03/07 10:33] luke7858mysql_engines [2024/05/23 07:26] (current) – external edit 127.0.0.1
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: 2024/05/23 07:26 (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