what is column known in mysql code example
Example 1: get the mysql table columns data type mysql
SHOW COLUMNS FROM mydb.mytable;
Example 2: mysql show table fields
DESCRIBE my_table;
SHOW COLUMNS FROM mydb.mytable;
DESCRIBE my_table;