I want to query the column names and comments of the table. The language names are as follows, SELECT
column_name AS 'field name',
data_type AS 'field type',
column_comment AS 'Field description'
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'jxc'
AND table_name = 'bill';
The result column name is displayed as tbl_structure.php?change_column=1&field=billid&token=c7bd3ebcea5be9e7a15f09d3f149036e
In fact, billid is the real column name. I'd like to ask the experts what's going on, and I won't hesitate to give you some advice! Thanks