- 论坛徽章:
- 0
|
回楼上
show create table books结果为:
CREATE TABLE `books` (\n `bookid` int(11) NOT NULL auto_increment,
\n `holdBy` int(11) NOT NULL,
\n `title` varchar(100) NOT NULL,
\n `author` varchar(50) default NULL,
\n `isbn` varchar(10) default NULL,
\n `price` double default NULL,
\n `postDate` date NOT NULL,
\n `description` text,
\n `status` varchar(5) NOT NULL default 'yes',
\n `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
\n `imagePath` varchar(50) default NULL,
\n `imageStatus` varchar(5) NOT NULL default 'no',
\n PRIMARY KEY (`bookid`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1
insert语句
INSERT INTO `books` ( `bookid` , `holdBy` , `title` , `author` , `isbn` , `price` , `postDate` , `description` , `status` , `timestamp` , `imagePath` , `imageStatus` )
VALUES ('', 'test', 'test', 'test', 'test', '21', '2006-04-19', 'test', 'yes', NOW( ) , NULL , 'no'
); |
|