Show table structure in mysql

 DESCRIBE tablename MariaDB [mytestingdb]> describe country; +------------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------------------+----------------+ | id | bigint(20) | NO | PRI | NULL | auto_increment | | name | varchar(255) | NO | | NULL | | | created_at | timestamp | NO | | current_timestamp() | | | updated_at | timestamp | NO | | current_timestamp() | | +------------+--------------+------+-----+---------------------+----------------+