1. Show all table names and engine types in MySQL

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