MySQL 8.0

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

create table t (tid int auto_increment primary key, x int, a varchar(255))
insert into t(x, a) values (1, 'a'), (3, 'z')
create table t2 as select * from t where 1 = 0
alter table t2 add column id int auto_increment primary key first
describe t2


Field
Type
Null
Key
Default
Extra


id
int(11)
NO
PRI
null
auto_increment

tid
int(11)
NO

0


x
int(11)
YES

null


a
varchar(255)
YES

null



insert into t2
    select null, t.*
    from t
select * from t2


id
tid
x
a


1
1
1
a

2
2
3
z

Field	Type	Null	Key	Default	Extra
id	int(11)	NO	PRI	null	auto_increment
tid	int(11)	NO		0
x	int(11)	YES		null
a	varchar(255)	YES		null