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