ExpertRefresh

Administration / 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


References



n/a