Select from describe sql

SELECT COLUMN_NAME AS `Field`, COLUMN_TYPE AS `Type`, IS_NULLABLE AS `NULL`, 
       COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS `Extra`
FROM information_schema.COLUMNS  
WHERE TABLE_SCHEMA = 'schemaName' AND TABLE_NAME = 'table1';

Source: stackoverflow.com

Similar codes

0 vote176 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote188 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote172 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
3 votes241 views1 answer
How to get yesterday date in sql
SQL
1 vote180 views2 answers
Maximum number of tables in mysql
SQL
6 votes173 views1 answer
Oracle trigger after connect
SQL
0 vote182 views1 answer
Get cpu details sql
SQL
14 votes167 views1 answer
Excel
SQL
0 vote222 views1 answer
Merge clause with inner join
SQL
2 votes174 views1 answer
Oracle find constraints referencing a table
SQL