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.
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
7 freelancers are bidding on average $36 for this job
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