MySQL error #1137 can not reopen temp table

I am using Mysql and created procedure using multiple temp table when I run my proc It returns an error #1137 can not reopen

I will give you all resources according to my proc.

1. I need to solve error and work my proc in offiline and online mysql

2. I tried my best and created a MySQL proc which returns unattempted and Re-Exam for single using studentID as Parameter and Mutiple Studetn using BatchCode as Param I can share with you but this it omits some unattempt courses and fine returns all ReExam courses.

I have another procedure for returning a single student report unattempted and Re-Exam course and it works fine. But when I come to multiple student like batch it returns different you can check first student report in batch he/she has onliy 2 unattempted and 6 Re-Exam courses in single he/she has 4 unattempted and 6 Re-Exam courses.

I can share the two proc currently I am using.

3. Referring to the previous report I also need a procedure that returns a certain number of unattempt and Re-Exam courses that the user need.

For example, “print out every student who have more than 5 unattempt and Re-Exam course”.

so, it should not contradict each other in terms of single student report unattempt and Re-Exam.

Skills: MySQL, PHP, SQL, Database Administration, Database Programming

See more: capturing mysql error messages php, php capturing mysql error, mysql error 1054 cre loaded, mysql can't reopen temp table, mysql use temporary table multiple times, mysql with, mysql temporary table error code 1137 can t reopen table, duplicate temporary table mysql, mysql can't reopen table union, mysql temporary table, mysql temporary table doesn't exist, display mysql rows php link full table, mysql error 2006 hy0000, add products mysql error occured cubecart, sendstudio 2004 mysql error, mysql error code 1054 using case, oscommerce psigate mysql error, mysql error 2013 godaddy, mysql error 1146 creloaded, tikiwiki warning mysql error duplicate entry

About the Employer:
( 5 reviews ) mogadishu, Somalia

Project ID: #27581980

Awarded to:


hi I have more than 10 years of professional experience in sql development and optimisation and worked in more than 300 projects in different database like Oracle,mysql/db2/ [login to view URL] discuss your requirements

$56 USD in 1 day
(17 Reviews)

7 freelancers are bidding on average $36 for this job


I can help with troubleshooting of described MySQL issue in an effective way due to my deep expertise in a database development and also because I am high-skilled in a bugs investigation. My professional SQL developmen More

$68 USD in 1 day
(19 Reviews)

Hi I have read the description and can do the work. I have 8 years of experience in Mysql,PHP,[login to view URL] me so we can [login to view URL] forward to work with you. Thanks

$30 USD in 2 days
(2 Reviews)

Hi, I am Parul. i have 8 years experience in developing field as senior software developer. due to covid-19 pandemic, i am here looking for project as freelance. you never feel regret , if you give me chance to do your More

$20 USD in 2 days
(0 Reviews)

I have good knowledge in sql, mysql, oracle, and sqlyog. I had 6 months of work experience in sql and jquery.

$20 USD in 7 days
(0 Reviews)

Hi Friend, I am a software engineer with 6 year of experience in Database and ETL technology. I have gone through your problem statement and sample files attached , I already worked many SQL problems so far in my orga More

$27 USD in 5 days
(0 Reviews)

Hi! This error is due to a MySQL limitation. The SQL query needs to be rewritten. I can help.

$30 USD in 1 day
(0 Reviews)