- 论坛徽章:
- 0
|
用mysqldump命令export出来的的语句:
CREATE TABLE /*!32312 IF NOT EXISTS*/ `wa_partitialsense` (
`id` int(11) NOT NULL auto_increment,
`lemmaid` int(11) default NULL,
`description` text,
`sortsequence` int(11) default NULL,
`ownerid` int(11) default NULL,
`changestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
用phpmyadmin export出来:
CREATE TABLE /*!32312 IF NOT EXISTS*/ `wa_partitialsense` (
`id` int(11) NOT NULL auto_increment,
`lemmaid` int(11) default NULL,
`description` text,
`sortsequence` int(11) default NULL,
`ownerid` int(11) default NULL,
`changestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; AUTO_INCREMENT=5678
这个AUTO_INCREMENT=5678的值我希望在使用mysqldump时也能出现。 |
|