KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
CREATE TABLE `batchinfo` ( `rowid` int(11) NOT NULL AUTO_INCREMENT, `datapath` mediumtext, `analysistime` varchar(50) DEFAULT NULL, `reporttime` varchar(50) DEFAULT NULL, `lastcalib` varchar(50) DEFAULT NULL, `analystname` varchar(150) DEFAULT NULL, `reportname` varchar(150) DEFAULT NULL, `batchstate` varchar(150) DEFAULT NULL, `instrument` varchar(20) DEFAULT NULL, PRIMARY KEY (`rowid`), UNIQUE KEY `rowid_UNIQUE` (`rowid`) ) ENGINE=InnoDB AUTO_INCREMENT=15034 DEFAULT CHARSET=latin1 I want to start the auto incremenet from 20000. How do I do that? Can I edit the table some how to start incrementing from 20000?
Tags (comma-separated)
Save Edits
Cancel