Get table engine type
You have to go to the mysql system database 1st
This allows you to see which type of table engine you're using
Common types:
myisam: doesn't support the features listed below for innodb
innodb (default) : supports r-trees (good for spatial extensions), enforces foreign keys, and supports transactions
select table_name, engine from tables where table_schema = "vsn";
No comments:
Post a Comment