mysqlGet table engine
SELECT engine FROM information_schema.tables WHERE table_name = 'table' AND table_schema = 'db';ctrl + cenginewill return specified table engine | information_schema.tablessystem table with metadata |
'table'table name to get engine for | 'db'database name where table is located |
More of Mysql
- How to find my.cnf config file
- Get largest tables list
- Insert new values only if row doesn't exist already
- Truncate all tables in a specific database
- Make a pager (limit / offset) select query
- How to find duplicate varchar/text column values in table
- What is the MEDIUMTEXT column max size (length) in Mysql
- Replace string with regex
- How to duplicate table structure and data
- Get server version
See more codes...