sql show columns in table
DESCRIBE table1; -- result: +----------------------+---------------------------+------+-----+-------------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------------+------+-----+-------------------+ | film_id | smallint(5) unsigned | NO | | 0 | | | title | varchar(128) | NO | | NULL | | | description | text | YES | | NULL | | | release_year | year(4) | YES | | NULL | | | language_id | tinyint(3) unsigned | NO | | NULL | | | original_language_id | tinyint(3) unsigned | YES | | NULL | | | rental_duration | tinyint(3) unsigned | NO | | 3 | | | rental_rate | decimal(4,2) | NO | | 4.99 |
