Why are the column names and comments of the query table displayed like this in mysql?
文韬
文韬 2021-05-30 22:08:49
0
0
962

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

文韬
文韬

reply all (0)
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!