avatar
find table schema in SQL MySQL

Use the query will return the column names along with their corresponding data types for the specified table as below:

SELECT column_name, data_type 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE table_name = '<table name>';
24
pick database mysql show tables mysql update table mysql
You need to login to do this manipulation!