mysql - Use variable in statement across multiple DBCommands (.net)

Question

I want to verify an observation since I'm not able to find anything about that.

Situation is that I'm having many sql-statements that will be executed on the database (mysql) statement by statement.

INSERT INTO A () ...
SELECT @lastident := last_insert_id();
INSERT INTO B SET ..., @last_ident, ...
INSERT INTO B SET ..., @last_ident, ...
INSERT INTO B SET ..., @last_ident, ...

These five lines are not executed as batch. Each row is a single statement in 'statements': (Code is just for demonstration simplified)

using(var connection = ... opening connection)
using(var transaction = ... starting transaction)
{
    foreach (var s in statements)
    {
        var cmd = ... creation of dbCommand;
        cmd.CommandText = s;
        cmd.ExecuteNonQuery();
    }
}

Note: Execution per statement is given in this context.

The variable @lastident works in each following statement. So my observation on the database.

What is the lifetime of the variable?

question from:https://stackoverflow.com/questions/65952172/use-variable-in-statement-across-multiple-dbcommands-net

Answer 1

Waitting for answers