SELECT
TABLE_SCHEMA as TBDATA,
TABLE_NAME as TBNAME,
TRIM(COLUMN_NAME) as TBCOLUMN,
UPPER(TRIM(COLUMN_NAME)) as TBCONDITION,
COLUMN_TYPE as TBTYPE,
if(LENGTH(COLUMN_COMMENT)>0,COLUMN_COMMENT,'') as TBMARK,
if(LENGTH(COLUMN_DEFAULT)>0,COLUMN_DEFAULT,'') as TBDEFAULT
FROM information_schema.`COLUMNS`
WHERE TABLE_SCHEMA='xxzgemail' and TABLE_NAME='aqhb_tian'