设置mysql表的自动增量初始值 [英] set auto increment initial value for mysql table

问题描述

我正在尝试使用PHP在sql中创建一个表，但不确定如何为自动增量字段设置初始值.

这是我到目前为止所拥有的:

function create_table($db_host,$db_user,$db_pswrd,$db_name){

$connect = mysql_connect($db_host,$db_user,$db_pswrd) or die(mysql_error());

mysql_select_db($db_name, $connect);
 $sql = "CREATE TABLE MY_TABLE
 (
table_id int NOT NULL AUTO_INCREMENT, 
 PRIMARY KEY(table_id),
 table_1 varchar(45),
 table_2 varchar(45),
 table_3 varchar(999),
 table_4 varchar(45)
 )"or die(mysql_error());

 mysql_query($sql,$connect)or die(mysql_error());

mysql_close($connect);

}

所以我需要知道创建后如何在此表上设置初始自动增量值吗?

谢谢

解决方案

如果表中还没有自动递增列:

$sql = "ALTER TABLE MY_TABLE ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    ADD INDEX (id);";

然后设置自动增量起始值:

$sql = "ALTER TABLE MY_TABLE AUTO_INCREMENT = 111111;";

---

此帖子的可能重复项. /p>

I'm trying to create a table in my sql using PHP but I'm not sure how to set an initial value for the auto increment field.

This is what i have so far:

function create_table($db_host,$db_user,$db_pswrd,$db_name){

$connect = mysql_connect($db_host,$db_user,$db_pswrd) or die(mysql_error());

mysql_select_db($db_name, $connect);
 $sql = "CREATE TABLE MY_TABLE
 (
table_id int NOT NULL AUTO_INCREMENT, 
 PRIMARY KEY(table_id),
 table_1 varchar(45),
 table_2 varchar(45),
 table_3 varchar(999),
 table_4 varchar(45)
 )"or die(mysql_error());

 mysql_query($sql,$connect)or die(mysql_error());

mysql_close($connect);

}

So i need to know how to set the initial Auto Increment value on this table, upon creation?

Thanks

解决方案

If you don't have the auto-increment column in the table yet:

$sql = "ALTER TABLE MY_TABLE ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    ADD INDEX (id);";

Then to set the auto-increment starting value:

$sql = "ALTER TABLE MY_TABLE AUTO_INCREMENT = 111111;";

---

Potential duplicate of this post.

这篇关于设置mysql表的自动增量初始值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！