列名、列注释等

SELECT  t.TABLE_NAME,  t.COLUMN_NAME,  t.COLUMN_TYPE,  t.COLUMN_COMMENT,  t.COLUMN_DEFAULTFROM information_schema.columns tWHERE t.TABLE_NAME = 'salary_bill_record';

表创建 SQL

SHOW CREATE TABLE salary_bill_record;