create table tb_Name(
id int auto_increment,
user_name varchar(20),
email varchar(20),
age int,
key (email),
primary key (id),
unique key (user_name)
id int auto_increment,
user_name varchar(20),
email varchar(20),
age int,
key (email),
primary key (id),
unique key (user_name)
);
上述适用于mysql数据库及mariadb数据库