Go4Expert - View Single Post - how to change default min sequence value for database

pein87

Code: SQL

ALTER TABLE table_name AUTO_INCREMENT = 1000;

do this before any rows are inserted so perform this right after the CREATE TABLE clause.

pein87 Ambitious contributor
28May2012,22:21
	Code: SQL ALTER TABLE table_name AUTO_INCREMENT = 1000; do this before any rows are inserted so perform this right after the CREATE TABLE clause.