MemoryRefresh!

Administration / Create table     Create table



Questions Answers 0%

Pages   0 from 12
Questions   0 from 14

Reset


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





Programming

Php
   
Regex
   
MySQL
   
Css
   
jQuery
   
Git
   


References
n/a