ExpertRefresh

Create table

1) How do you create a table?




2) How do you get table structure?






Create table CREATE TABLE mytable ( id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, myname VARCHAR(30) ) Get table structure SHOW CREATE TABLE mytable; -- result: CREATE TABLE `mytable` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `myname` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1