Sometimes we need to check the CREATE TABLE syntax for already created table in the database. When we need to check what kind of columns and what datatype a column has in a table then we require the ...
DROP TABLE IF EXISTS `foo_table`; CREATE TABLE `foo_table` ( `FOO_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `BAZ_NM` varchar(250) DEFAULT NULL, PRIMARY KEY (`FOO_ID`) ); In the resulting output ...