Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > mysql > answers

Reset AutoIncrement Colume value

  #1  
Old August 28th, 2008, 06:33 PM
Newbie
  
Join Date: Aug 2008
Posts: 1
I need to change the value for a autoincrement value to start value of 10000 not 0. The column already exists.
  #2  
Old August 28th, 2008, 10:26 PM
Atli's Avatar
Moderator
  
Join Date: Nov 2006
Location: Iceland
Posts: 3,702
Provided Answers: 4

re: Reset AutoIncrement Colume value

Hi.

You could use the ALTER TABLE syntax.
Like:
Expand|Select|Wrap|Line Numbers
  1. ALTER TABLE myTable AUTO_INCREMENT = 10000;
  2.  
Reply

« previous question | next question »

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 225,702 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved