1 示例 1
1.1 创建表
DROP TABLE AT240715;
CREATE TABLE "SYSDBA"."AT240715"
(
"ID" INT PRIMARY KEY AUTO_INCREMENT ,
"NAME" CHAR(10)
);
TRUNCATE TABLE AT240715;
insert into AT240715(name) values('A1');
select LAST_INSERT_ID;
insert into AT240715(name) values('A2');
COMMIT;
select LAST_INSERT_ID;
1.2 结果集
结果集1
结果集2
2 示例 2
2.1 创建表
DROP TABLE AT24071502;
CREATE TABLE "SYSDBA"."AT24071502"
(
"IDD" INT PRIMARY KEY AUTO_INCREMENT ,
"NAME" CHAR(10)
);
TRUNCATE TABLE AT24071502;
insert into AT24071502(name) values('A1');
insert into AT24071502(name) values('A2');
select LAST_INSERT_ID;
insert into AT24071502(name) values('A3');
COMMIT;
select LAST_INSERT_ID;
2.2 结果集
- 结果集 1
- 结果集 2