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

Reset AutoIncrement Colume value

Newbie
  
Join Date: Aug 2008
Posts: 1
#1: Aug 28 '08
I need to change the value for a autoincrement value to start value of 10000 not 0. The column already exists.

Atli's Avatar
Moderator
  
Join Date: Nov 2006
Location: Iceland
Posts: 3,748
#2: Aug 28 '08

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 »

Similar MySQL Database bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/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 226,449 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