mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
16 lines
482 B
Text
16 lines
482 B
Text
create table t1 (c2 int as (1+1), c1 int primary key auto_increment) engine=innodb;
|
|
insert into t1(c1) values (null),(null),(null);
|
|
select * from t1;
|
|
c2 c1
|
|
2 1
|
|
2 2
|
|
2 3
|
|
alter table t1 auto_increment = 3;
|
|
show create table t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
`c2` int(11) GENERATED ALWAYS AS (1 + 1) VIRTUAL,
|
|
`c1` int(11) NOT NULL AUTO_INCREMENT,
|
|
PRIMARY KEY (`c1`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
|
drop table t1;
|