获取数据库所有表的语句。
SELECT
table_name tableName,
ENGINE,
table_comment tableComment,
create_time createTime
FROM
information_schema.TABLES
WHERE
table_schema = ( SELECT DATABASE ( ) )
拿到表之后,可以获取表的所有字段。
SELECT
column_name columnName,
data_type dataType,
column_comment columnComment,
column_key columnKey,
extra
FROM
information_schema.COLUMNS
WHERE
table_name = 'table_name'
AND table_schema = ( SELECT DATABASE ( ) )
ORDER BY
ordinal_position