SELECT
COLUMN_NAME 字段名称,
COLUMN_TYPE 字段类型,
( CASE WHEN is_nullable = 'NO' THEN 'NOT NULL' ELSE '' END ) AS 默认值
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
table_schema = 'pilotplatform' AND table_name = 'abpuserroles'
mysql 查询表结构信息
于 2022-06-14 09:13:02 首次发布