This time, I will make a closer look at mysql user variables. They can be divided into two main categories: defined variables, used in procedures and functions and undefined, also can be used in procedures and function, but also can be used in sql queries as in-line code.
Problem is as old as a world – how to get next ID value in MySQL assuming, AUTO_INCREMENT is in use. If ID value is needed after record is submitted and if ID value is needed before insertion is made.
