PROGRAMMING
Php
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
... 2 lines ➥ Questions
