1. Show all table names and engine types in MySQL

    SELECT table_name,engine FROM INFORMATION_SCHEMA.TABLES WHERE table_schema=DATABASE();
     
  1. steadypic likes this
  2. mildredbod8 likes this
  3. stephensok85 likes this
  4. kathleentag901 likes this
  5. plushcode posted this