mysqlのテーブル構造情報の取得
673 ワード
SELECT
COLUMN_NAME ,
COLUMN_TYPE ,
DATA_TYPE ,
CHARACTER_MAXIMUM_LENGTH ,
IS_NULLABLE ,
COLUMN_DEFAULT ,
COLUMN_COMMENT
FROM
INFORMATION_SCHEMA.COLUMNS
where
-- developerclub ,
-- table_schema ='developerclub'
-- AND
-- article ,
-- , , ,
table_name = 'xx_test'