Home › Forums › General Webmaster Forum ›

Mysql auto_increment lower than highest ID

Submitted by Anonymous on Thu, 03/18/2010 - 11:40

I am developing an international news-magazine site. I must migrate nearly 50 old news to. I have added 10 old news to test and decide to add old news later. Therefore I have changed auto_increment value from 15 to 100 to keep IDs between 15-100 empty & reserved for old news. I have added some new content and now I have time to add old content. But now when I try to change the auto_increment value from 137 to 15 over phpmyadmin I get see still 137 as last auto increment id. How to go down for autoincrement number?

Bookmark/Search this post with
‹ Fatal error: Call to undefined function block_list() in /includes/theme.inc on line 1586 Seoquake - powerful search engine optimization tool for Mozilla Firefox ›
Tags:

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Use <pre> all your html php come here </pre> for your code
  • Allowed HTML tags: <a> <b> <pre> <h1> <h2> <h3> <h4> <h5> <h6> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <div> <style><img> <br> <blockquote>
  • Lines and paragraphs break automatically.
  • You may insert videos with [video:URL]

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.

CafeWebmaster.com(CW) is a free online community for webdevelopers and beginners. Anybody can share their code, articles, tips, tutorials, code-examples or other webdesign related material on the site. Newbies can submit their questions and reply to existing questions. CW does not guarantee or warrant reliability of code, data and information published on the site. Use the site on your own risk. The site takes no responsibility of direct or indirect loss or any kind of harm to its users. The site also doesn't take responsibility of infected files or source code with any kind of infection or viruses, worms, spywares, malwares, trojan horses. CW reserves the right to edit, move, or delete any of content for any reason.