Mysql 对象管理 序列

1. 创建自增序列表

  CREATE TABLE article ( 
                  id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, 
                  title VARCHAR(200), 
                  body TEXT, 
                  FULLTEXT(title, body) 
              );

2. 插入数据

insert into dsg.article (title,body) values('serch','大圣');
insert into dsg.article (title,body) values('serch','齐天大圣');
insert into dsg.article (title,body) values('serch','齐天大圣,孙悟空');
insert into dsg.article (title,body) values('serch','齐天大圣孙悟空');
insert into dsg.article (title,body) values('serch','齐天大圣啊!');
insert into dsg.article (title,body) values('serch','齐天大圣,大圣');
insert into dsg.article (title,body) values('serch','齐天大,圣');
insert into dsg.article (title,body) values('serch','good 孙悟空');
insert into dsg.article (title,body) values('serch','hello 孙悟空');
insert into dsg.article (title,body) values('serch','hello');
insert into dsg.article (title,body) values('serch','hello');
insert into dsg.article (title,body) values('serch','hello');
insert into dsg.article (title,body) values('serch','hello');
insert into dsg.article (title,body) values('serch','hello');
insert into dsg.article (title,body) values('serch','hello');
insert into dsg.article (title,body) values('serch','hello');
insert into dsg.article (title,body) values('serch','hello');
insert into dsg.article (title,body) values('serch','hello');
insert into dsg.article (title,body) values('serch','hello');
insert into dsg.article (title,body) values('serch','hello');

3. 查询最后自增序列的值:

mysql> select last_insert_id()
    -> ;
+------------------+
| last_insert_id() |
+------------------+
|               20 |
+------------------+
1 row in set (0.00 sec)

4. 设定变量为某个值

mysql> set identity=30
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> select last_insert_id();
+------------------+
| last_insert_id() |
+------------------+
|               30 |
+------------------+
1 row in set (0.00 sec)

• 在插入新值

mysql> insert into dsg.article (title,body) values('serch','hello');
Query OK, 1 row affected (0.24 sec)

mysql>  select last_insert_id();
+------------------+
| last_insert_id() |
+------------------+
|               21 |
+------------------+
1 row in set (0.00 sec)