CREATE TABLE `tab_incoming_project` (
`id` int(11) NOT NULL auto_increment,
`proId` int(11) NOT NULL,
`projectName` varchar(255) NOT NULL,
`partner` int(11) NOT NULL,
`yearMon` date NOT NULL,
`startDate` date default NULL,
`endDate` date default NULL,
`effDays` float(11,2) default NULL,
`checkStartDate` int(11) default NULL,
`createDate` date NOT NULL,
`status` int(1) NOT NULL default '0',
`count` int(4) NOT NULL default '0',
PRIMARY KEY (`id`)
`id` int(11) NOT NULL auto_increment,
`proId` int(11) NOT NULL,
`projectName` varchar(255) NOT NULL,
`partner` int(11) NOT NULL,
`yearMon` date NOT NULL,
`startDate` date default NULL,
`endDate` date default NULL,
`effDays` float(11,2) default NULL,
`checkStartDate` int(11) default NULL,
`createDate` date NOT NULL,
`status` int(1) NOT NULL default '0',
`count` int(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=256 DEFAULT CHARSET=utf8;
AUTO_INCREMENT=256的设置就是从第256开始增长