title: How do I start auto increment from a specific point?
body: <pre><code>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
  </code></pre>
  <p>I want to start the auto incremenet from 20000.</p>
  <p>How do I do that? Can I edit the table some how to start incrementing from 20000?</p>