blob: 4885b5f8a26731f47e336554876e7dbc0958941c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
#
# Create
#
create temporary sequence s1 engine=innodb;
alter table s1 engine myisam;
select nextval(s1);
nextval(s1)
1
select * from s1;
next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
1001 1 9223372036854775806 1 1 1000 0 0
drop temporary sequence s1;
|
