Làm cách nào để tạo số sê-ri trong MySQL?

MariaDB có Công cụ lưu trữ SEQUENCE. Vì vậy, nếu bạn đang sử dụng MariaDB, tất cả các sự cố trình tự của bạn đã kết thúc [hoặc chỉ mới bắt đầu]

Dãy 10 số

select * from seq_1_to_10;

Dãy 10 số

select * from
[select 0 x union select 1 union select 2 union select 3 union select 4 union
select 5 union select 6 union select 7 union select 8 union select 9] A;

Dãy 100 số

select [t*10+u+1] x from
[select 0 t union select 1 union select 2 union select 3 union select 4 union
select 5 union select 6 union select 7 union select 8 union select 9] A,
[select 0 u union select 1 union select 2 union select 3 union select 4 union
select 5 union select 6 union select 7 union select 8 union select 9] B
order by x;

Dãy 1000 số

select [h*100+t*10+u+1] x from
[select 0 h union select 1 union select 2 union select 3 union select 4 union
select 5 union select 6 union select 7 union select 8 union select 9] A,
[select 0 t union select 1 union select 2 union select 3 union select 4 union
select 5 union select 6 union select 7 union select 8 union select 9] B,
[select 0 u union select 1 union select 2 union select 3 union select 4 union
select 5 union select 6 union select 7 union select 8 union select 9] C
order by x;

Dãy số 10000

select [th*1000+h*100+t*10+u+1] x from
[select 0 th union select 1 union select 2 union select 3 union select 4 union
select 5 union select 6 union select 7 union select 8 union select 9] A,
[select 0 h union select 1 union select 2 union select 3 union select 4 union
select 5 union select 6 union select 7 union select 8 union select 9] B,
[select 0 t union select 1 union select 2 union select 3 union select 4 union
select 5 union select 6 union select 7 union select 8 union select 9] C,
[select 0 u union select 1 union select 2 union select 3 union select 4 union
select 5 union select 6 union select 7 union select 8 union select 9] D
order by x;

Dãy 10 số

use test
drop table if exists seq10;
create table seq10
[x int not null auto_increment primary key];
insert into seq10 values [],[],[],[],[],[],[],[],[],[];
select * from seq10;

Dãy 100 số

use test
drop table if exists seq100;
create table seq100
[x int not null auto_increment primary key];
insert into seq100 values [],[],[],[],[],[],[],[],[],[];
insert into seq100 values [],[],[],[],[],[],[],[],[],[];
insert into seq100 values [],[],[],[],[],[],[],[],[],[];
insert into seq100 values [],[],[],[],[],[],[],[],[],[];
insert into seq100 values [],[],[],[],[],[],[],[],[],[];
insert into seq100 select x + 50 from seq100;
select * from seq100;

Dãy 1000 số

use test
drop table if exists seq1000;
create table seq1000
[x int not null auto_increment primary key];
insert into seq1000 values [];
set @p= -1;
set @p=@p+1; insert into seq1000 select x+power[2,@p] from seq1000 where [x+power[2,@p]]