Query the column name in the table in MySql _ MySQL

For example, my database name is example, and USEexample is used. Are you sure you want to use the example database. Use showtables; to display all tables in the database. Use DESCpersons; to display the column names in the persons table. Or use DESCRIBEpersons; or use SHOWcolumns. for example, if my database name is "example", use

USE example;

Are you sure you want to use the example database. Use

Show tables;

Displays all tables in the database. Use

DESC persons;

Displays the column names in the persons table. Or use

DESCRIBE persons;

Or use

SHOW columns FROM persons;