See attached image.
Note how I executed this command:
Code:
INSERT INTO dart_info (roles) VALUES ('api');
SET @lastid = LAST_INSERT_ID();
— SELECT @lastid;
INSERT INTO user_has_dart_info (login_name,source_database,id_dart_info) VALUES ('Utimaco-API', 'ActiveDirectory', @lastid);
But the “Messages” window shows this:
Code:
/*[12:19:36 PM][ 15 ms]*/ INSERT INTO dart_info (roles) VALUES ('api');
/*[12:19:36 PM][ 0 ms]*/ SET @lastid = LAST_INSERT_ID();
/*[12:19:36 PM][ 0 ms]*/ — SELECT @lastid; INSERT INTO user_has_dart_info (login_name,source_database,id_dart_info) VALUES ('Utimaco-API', 'ActiveDirectory', @lastid);
Notice how the last line merges the TWO SQL statements into one. Most likely this is due to the SQL comment “–” marker.
ALL three SQL commands were executed:
Code:
(1 row(s) affected)
Execution Time : 00:00:00:015
Transfer Time : 00:00:00:000
Total Time : 00:00:00:015
(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
(1 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
Using SQLYog Ultimate 8.5
