Re: save LAST_INSERT_ID to variable

On 02/01/2022 11:19, [email protected] wrote:
> I'm researching the LAST_INSERT_ID command for MYSQL.
>
> from what i have seen - I can save it as a 'variable' as @variable =
> LAST_INSERT_ID();
>
> Question: What is the difference between @THIS_VARIABLE and
> $that_variable (with a dollar $ sign)??
>
> I cannot find ANY examples/tutorials that say we can save it as a  $variable.

You appear to be mixing too different languages / concepts here.

You can save a value to a variable in SQL, which uses @variable.

You can save a value to a variable in PHP, which uses $variable.

In the case of a value saved in SQL, the value can only be used in 
further SQL queries on the same SQL connection and cannot be used for 
other purposes (for example, using in a URL to forward the user to or 
creating a job queue message).

SQL variables are useful for scripting something in SQL, but if you're 
already using a scripting language such as PHP to perform a larger task, 
I think it's generally best to keep as much logic as possible there. 
(Additionally, in my experience many developers aren't familiar with SQL 
variables, so it reduces overhead for others maintaing the code in future)