C # Do not delete temporary tables in mysql automatically _ MySQL

C # Do not delete bitsCN.com automatically when operating temporary tables in mysql

Use c # to call the mysql stored procedure and use a temporary table in the stored procedure. each time the first call is correct, an error is returned when the refresh operation is performed. "The temporary table already exists ", the description in the temporary table is "only visible to the current connection. when the connection is closed, it will be automatically dropped", but the database connection is closed every time data operations are used up. Therefore, it is estimated that the buffer pool problem is solved by setting the mysql thread pool pooling to false, but it is not worthwhile to find a better solution. pooling does not have to affect performance in the case of large traffic volumes. Please advise

BitsCN.com