MYsql查看錶類型 備忘

標籤：小數   select   自增   數位   查看   default   where   允許   extra   

SELECT
COLUMN_NAME,
DATA_TYPE AS `資料類型`,
CHARACTER_MAXIMUM_LENGTH AS `字元長度`,
NUMERIC_PRECISION AS `數字長度`,
NUMERIC_SCALE AS `小數位元`,
IS_NULLABLE AS `是否允許非空`,
CASE WHEN EXTRA = ‘auto_increment‘ THEN 1 ELSE 0 END AS `是否自增`,
COLUMN_DEFAULT AS `預設值`,
COLUMN_COMMENT AS `備忘`
FROM information_schema.COLUMNS WHERE TABLE_NAME=‘BATTLEFIELD_DECISION‘

MYsql查看錶類型 備忘