Temporary table

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.