blob: 9edbd3c9b3bc93ae511936ff91b21863523741b5 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
DROP TABLE IF EXISTS ids;
DROP FUNCTION IF EXISTS last_insert_grn_id;
CREATE TABLE ids (
id int AUTO_INCREMENT PRIMARY KEY
) COMMENT='ENGINE "InnoDB"';
SELECT last_insert_grn_id();
last_insert_grn_id()
0
INSERT INTO ids VALUES();
SELECT last_insert_grn_id();
last_insert_grn_id()
0
SELECT * FROM ids;
id
1
DROP TABLE ids;
DROP FUNCTION last_insert_grn_id;
|
