Hi all,
I'm using the MYSQL connector for C# and I have a problem with a temporary table. I create it with the CREATE TEMPORARY TABLE command after doing the DROP TABLE IF EXISTS and then try to insert data into it. My problem is that I get an exception when I try to insert the data, saying that the table does not exist. But when I then try to create the table again, it says that the table already exists. This is very strange ans I can't seem to find the problem.
I don't know if it's worth mentioning, but the method I use did work at some point, but suddenly stopped working without changes to the code. I also do not create other temporary tables or anything that may conflict with this code.
I'm using the MYSQL connector for C# and I have a problem with a temporary table. I create it with the CREATE TEMPORARY TABLE command after doing the DROP TABLE IF EXISTS and then try to insert data into it. My problem is that I get an exception when I try to insert the data, saying that the table does not exist. But when I then try to create the table again, it says that the table already exists. This is very strange ans I can't seem to find the problem.
I don't know if it's worth mentioning, but the method I use did work at some point, but suddenly stopped working without changes to the code. I also do not create other temporary tables or anything that may conflict with this code.