show create table aaa; 查看aaa表的建表sql语句
CREATE TABLE `aaa` (
`inv` varchar(8) NOT NULL,
`rno` varchar(15) NOT NULL,
`part` varchar(11) NOT NULL,
`aot` decimal(9,2) NOT NULL,
`qy` tinyint(3) unsigned NOT NULL,
`rtype` varchar(20) NOT NULL,
`bcode` varchar(12) NOT NULL,
`rson` varchar(200) NOT NULL,
`tking` varchar(25) NOT NULL,
`mtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
KEY `inv` (`inv`,`part`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
CREATE TABLE `inv_li` (
`inv` varchar(8) NOT NULL DEFAULT '',
`channel` varchar(10) DEFAULT '',
`uid` int(10) unsigned DEFAULT '0',
`email` varchar(120) DEFAULT '',
`name` varchar(50) DEFAULT '',
`tot` double DEFAULT '0',
`autorun` char(1) DEFAULT 'Y',
`date_time` datetime DEFAULT '0000-00-00 00:00:00',
`sce` smallint(5) unsigned DEFAULT NULL,
`stated` enum('N','Y') NOT NULL DEFAULT 'N',
`isBAd` enum('E','U','N','Y') NOT NULL DEFAULT 'E',
`uptime` datetime NOT NULL,
`isGu` enum('N','Y') NOT NULL,
PRIMARY KEY (`inv`),
KEY `date_time` (`date_time`),
KEY `channel` (`channel`),
KEY `uid` (`uid`),
KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
posted on 2014-09-27 13:58
鱼有所思 阅读(180)
评论(0) 编辑 收藏 引用 网摘 所属分类:
MySQL