如题 怎样在创建表的时候设置自增字段的初始值和步进值?下面是我写的存储过程,报语法错误:
CREATE PROCEDURE CREATE_JABBERDTABLE()
BEGIN
DECLARE tableName VARCHAR(64);
DECLARE i INT DEFAULT 0;
WHILE(i < 20) DO
SET tableName = CONCAT('vsgroup_',i);
DROP TABLE IF EXISTS @tableName;
CREATE TABLE @tableName
(
groupid INT(11) AUTO_INCREMENT(i,20) PRIMARY KEY,
);
END WHILE;END
CREATE PROCEDURE CREATE_JABBERDTABLE()
BEGIN
DECLARE tableName VARCHAR(64);
DECLARE i INT DEFAULT 0;
WHILE(i < 20) DO
SET tableName = CONCAT('vsgroup_',i);
DROP TABLE IF EXISTS @tableName;
CREATE TABLE @tableName
(
groupid INT(11) AUTO_INCREMENT(i,20) PRIMARY KEY,
);
END WHILE;END
auto_increment_offset确定AUTO_INCREMENT列的起点
mysql> SET auto_increment_offset=5;
mysql> SET auto_increment_increment=10;
mysql> SHOW VARIABLES LIKE 'auto_inc%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| auto_increment_increment | 10 |
| auto_increment_offset | 5 |
+--------------------------+-------+
2 rows in set (0.00 sec)
建议一次性把所有问题都提出,不要回答完一个紧跟一个。