1drop table if exists t1;
2## Creating new table ##
3CREATE TABLE t1
4(
5id INT NOT NULL auto_increment,
6PRIMARY KEY (id),
7name VARCHAR(30)
8) ENGINE = INNODB;
9'#--------------------FN_DYNVARS_059_01-------------------------#'
10## Verifying initial value of ##
11SELECT @@session.last_insert_id;
12@@session.last_insert_id
130
14## Inserting records in table t1 ##
15INSERT into t1(name) values('Record_1');
16INSERT into t1(name) values('Record_2');
17SELECT * from t1;
18id	name
191	Record_1
202	Record_2
21## Verifying value of variable after inserting some rows ##
22SELECT @@session.last_insert_id = 2;
23@@session.last_insert_id = 2
241
25'#--------------------FN_DYNVARS_059_02-------------------------#'
26## Creating & connecting to new connection test_con1 ##
27SET @@autocommit = 0;
28## Verifying initial value of variable in new connection ##
29SELECT @@session.last_insert_id;
30@@session.last_insert_id
310
32## Inserting rows in table t1 ##
33START TRANSACTION;
34INSERT into t1(name) values('Record_3');
35INSERT into t1(name) values('Record_4');
36INSERT into t1(name) values('Record_5');
37## Verifying value of variable without committing rows ##
38SELECT @@session.last_insert_id;
39@@session.last_insert_id
405
41'#--------------------FN_DYNVARS_059_03-------------------------#'
42## Creating & connecting to new connection test_con2 ##
43## Inserting values through new connection ##
44INSERT into t1(name) values('Record_6');
45INSERT into t1(name) values('Record_7');
46SELECT * from t1;
47id	name
481	Record_1
492	Record_2
506	Record_6
517	Record_7
52## Verifying value of variable in second connection ##
53SELECT @@last_insert_id;
54@@last_insert_id
557
56'#--------------------FN_DYNVARS_059_04-------------------------#'
57## Switching to test_con1 ##
58## Verifying all records in table & value of variable ##
59SELECT * from t1;
60id	name
611	Record_1
622	Record_2
633	Record_3
644	Record_4
655	Record_5
666	Record_6
677	Record_7
68SELECT @@session.last_insert_id;
69@@session.last_insert_id
705
71## Commiting records in table ##
72COMMIT;
73SELECT @@session.last_insert_id;
74@@session.last_insert_id
755
76## Switching to test_con2 & verifying value of variable in it ##
77SELECT @@session.last_insert_id;
78@@session.last_insert_id
797
80'#--------------------FN_DYNVARS_059_05-------------------------#'
81## Setting value of variable ##
82SET @@session.last_insert_id = 100;
83SELECT @@session.last_insert_id;
84@@session.last_insert_id
85100
86## Inserting new record and verifying variable's effect on it ##
87INSERT into t1(name) values('Record_8');
88SELECT @@session.last_insert_id;
89@@session.last_insert_id
908
91## Dropping table t1 ##
92drop table t1;
93## Disconnecting both the connections ##
94