SELECT @rownum:=@rownum+1 AS rownum, table_name.*
FROM (SELECT @rownum:=0) r, table_name
select COLUMN_NAME,COLUMN_COMMENT,DATA_TYPE,IS_NULLABLE from information_schema.columns
where table_schema = 'HZ_ZJJ'
and table_name = 'ZJJ_T_ZZJGDMXX' ;