MariaDB 10.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


10.5.17-MariaDB-1:10.5.17+maria~deb11


create table starachive (id int unsigned primary key auto_increment not null, a int)
insert into starachive select NULL, seq FROM seq_1_to_10;

Records: 10  Duplicates: 0  Warnings: 0


select * from starachive;


id
a


1
1

2
2

3
3

4
4

5
5

6
6

7
7

8
8

9
9

10
10


insert into starachive(a) select seq FROM seq_144_to_155

Records: 12  Duplicates: 0  Warnings: 0


select * from starachive;


id
a


1
1

2
2

3
3

4
4

5
5

6
6

7
7

8
8

9
9

10
10

16
144

17
145

18
146

19
147

20
148

21
149

22
150

23
151

24
152

25
153

26
154

27
155

id	a
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	10
16	144
17	145
18	146
19	147
20	148
21	149
22	150
23	151
24	152
25	153
26	154
27	155

id	a
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	10
16	144
17	145
18	146
19	147
20	148
21	149
22	150
23	151
24	152
25	153
26	154
27	155

id	a
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	10
16	144
17	145
18	146
19	147
20	148
21	149
22	150
23	151
24	152
25	153
26	154
27	155