AUTO_INCREMENT 설정

auto_increment 값 1000부터 테이블 생성

create table 테이블 (
num int(11) unsigned not null auto_increment primary key
) type=myisam auto_increment=1000;

auto_increment 값 변경

alter table 테이블명 auto_increment=1000;

현재 auto_increment 값 알기

$SQL = "SHOW TABLE STATUS LIKE 'TableName'";

mysql> show table status like "tableName" G
*************************** 1. row ***************************
Name: tablename
Type: MyISAM
Row_format: Dynamic
Rows: 30154
Avg_row_length: 330
Data_length: 9962860
Max_data_length: 4294967295
Index_length: 1963008
Data_free: 0
Auto_increment: 104136
Create_time: 2005-05-31 11:57:59
Update_time: 2006-02-06 22:10:02
Check_time: NULL
Create_options:
Comment:
1 row in set (0.00 sec)