I have created store procedure in MySQL. Inside store procedure I am using temporary table.
This temporary table is not get created.
If I change to permanent table it is working.
I have created store procedure in MySQL. Inside store procedure I am using temporary table.
This temporary table is not get created.
If I change to permanent table it is working.
Please share more details: an example of a procedure, Go code snippet.
is this Go related?
what do you tried so far?
If you are creating your temporary table in a stored procedure, that table does not persist after the SP ends
According to me, I am using transactions in golang and the stored procedure is executed within the transaction .
It should be available .
doesn’t seem go related, but have a read here MySQL :: Temporary tables are now allowed in transactions when GTIDs are enabled.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.