MySQL ID自增:是通过auto_increment实现自增
create table a(
id int not null auto_increment primary key,
name varchar(10)
);
#注意其自增列必须为主键
INSERT INTO a VALUES (NULL,'jack');
INSERT INTO a VALUES (NULL,'rose');
SELECT * FROM a;
Oracle ID自增:sequence+触发器实现自增
create table b(
Id number primary key</