Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to change autoincrement in mysql

Status
Not open for further replies.
hos2

hos2

Programmer
Joined
May 6, 2002
Messages
418
Location
NL
If I make a table with an autoincrement key it will always start with 1. How can I change it so that the first record starts at 1000 for example ?????

 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

R
  • Locked
  • Question Question
How Can I Use MySQL To Send Data To An Email
Replies
1
Views
868
Chris Miller
Chris Miller
W
  • Locked
  • Question Question
how to send checked row data in php
Replies
0
Views
611
wiltang2004
W
SashaBuilder3
  • Locked
  • Question Question
import CSV file into MySql table in PhpMyAdmin
Replies
0
Views
1K
SashaBuilder3
SashaBuilder3
P
  • Locked
  • Question Question
JPgraph - How to stop a line graph from dropping to zero?
Replies
2
Views
946
Chris Miller
Chris Miller
ersatz
  • Locked
  • Question Question
How to send 2 select from mysql database in email like tables
Replies
5
Views
1K
ersatz
ersatz

Part and Inventory Search

Sponsor

Back
Top