创建表完整语句

最新推荐文章于 2021-10-03 00:38:54 发布

weixin_34174105

最新推荐文章于 2021-10-03 00:38:54 发布

阅读量124

点赞数

文章标签： python

原文链接：https://my.oschina.net/shunshun/blog/176817

版权

2019独角兽企业重金招聘Python工程师标准>>>

CREATE TABLE IF NOT EXISTS `people` (
`peopleid` smallint(6) NOT NULL AUTO_INCREMENT,
`firstname` char(50) NOT NULL,
`lastname` char(50) NOT NULL,
`age` smallint(6) NOT NULL,
`townid` smallint(6) NOT NULL,
`type` VARCHAR( 500 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '类型' ,
PRIMARY KEY (`peopleid`),
UNIQUE KEY `unique_fname_lname`(`firstname`,`lastname`),
KEY `fname_lname_age` (`firstname`,`lastname`,`age`)

) ENGINE =InnoDB DEFAULT CHARSET=utf8 ;

CREATE TABLE IF NOT EXISTS `postdata_{$month}` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`data` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`time` datetime NOT NULL ,
`type` smallint( 1 ) NOT NULL COMMENT '0字符型',
`uid` varchar( 50 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM default CHARSET = utf8 COLLATE utf8_unicode_ci

转载于:https://my.oschina.net/shunshun/blog/176817