Show Table Status equivalent from information_schema

from the Artful Common Queries page


Fill in schema and table names in ...


SELECT

  table_name,

  engine,

  version,

  row_format,

  table_rows,

  avg_row_length,

  data_length,

  max_data_length,

  index_length,

  data_free,

  auto_increment,

  create_time,

  update_time,

  check_time,

  table_collation,

  checksum,

  create_options,

  table_comment

FROM information_schema.tables

where table_schema='???' AND table_name='???';




Return to the Artful Common Queries page