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
- Truncate all tables in a specific database
- Disable ONLY_FULL_GROUP_BY mode
- Insert/update multiple rows in single query
- How to find my.cnf config file
- Get largest tables list
- Export database tables structure without data
- Rename table column
- Replace string with regex
- Skip certain tables while doing dump
- How to find duplicate varchar/text column values in table
See more codes...