In my method, I start the transaction, execute the sentence that creates the temporary table (thanks to the stored procedure) and finish the transaction. ![]() I explain myself, my application has the connection open permanently to the database all the time until I close the application. The question is, how do I keep the table open, insert values and retrieve the query?. when I check the database, the table doesn't exist. When I execute the stored procedure from my project (created in Xojo) I don't get any error but I don't know how to check if it is created perfectly since from programs with Navicat, Valentina Studio, etc. When I execute the stored procedure, no error appears but if I execute the following SQL sentence it tells me that the table does not exist: SET = CONCAT('CREATE TEMPORARY TABLE IF NOT EXISTS (ean13 VarChar(13)) Engine=MyISAM') SET = CONCAT('DROP temporary table if exists stmt1 FROM stmt1 ![]() The procedure that I have created is this: CREATE PROCEDURE `CrearTablaTemporal`(table_name VARCHAR(100)) I want to create a stored procedure in Mysql that removes a certain temporary table (if it exists) and then creates this temporary table in the database 'prs1'.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |