MySQL 查询表结构

列名、列注释等

SELECT
  t.TABLE_NAME,
  t.COLUMN_NAME,
  t.COLUMN_TYPE,
  t.COLUMN_COMMENT,
  t.COLUMN_DEFAULT
FROM information_schema.columns t
WHERE t.TABLE_NAME = 'salary_bill_record';

表创建 SQL

SHOW CREATE TABLE salary_bill_record;