how to strart auto_increment from 500000? (mysql)
[217 byte] By [xianwinwina] at [2007-11-27 6:24:44] 
Hi all,quick question, I have a table with the following prop:1. ID2. fname3. lnamethe Id is auto_increment. I wonder how can I start the count from say 50000?thank you
# 1
http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.htmlcotton.ma at 2007-7-12 17:43:53 >
# 2
thank youALTER TABLE tbl AUTO_INCREMENT = 100;solved!xianwinwina at 2007-7-12 17:43:53 >
Database Connectivity Hot Topic
- MYSQL connector
- ResultSet merge
- When we need to use connection.releaseSavepoint(sp); ?
- Sorting A Database Into Alphabetical Order?
- Problem with big table (Oracle DB)
- jdbc
- how to hide username/password in JDBC program.
- Can i store file in Database?
- JDBC Driver Problem
- Maximum Parameters for PreparedStatement
- Instantiation Error in JAR file
- number of rows returned by SELECT LAST(column)
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding