Jerms01 Posted December 11, 2014 Share Posted December 11, 2014 Have any of you ever run into this one. Can't quite figure this one out. Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE cUserID INT; DECLARE done INT DEFAULT FALSE; DECLARE CUR1 CURSOR FOR ' at line 9 Quote Link to comment https://forums.phpfreaks.com/topic/293047-unable-to-create-temp-table-in-proc/ Share on other sites More sharing options...
Solution requinix Posted December 11, 2014 Solution Share Posted December 11, 2014 DECLAREs have to come before everything else. Quote Link to comment https://forums.phpfreaks.com/topic/293047-unable-to-create-temp-table-in-proc/#findComment-1499360 Share on other sites More sharing options...
Jerms01 Posted December 12, 2014 Author Share Posted December 12, 2014 I will give that a shot thank you! Quote Link to comment https://forums.phpfreaks.com/topic/293047-unable-to-create-temp-table-in-proc/#findComment-1499405 Share on other sites More sharing options...
Jerms01 Posted December 12, 2014 Author Share Posted December 12, 2014 Thank you kindly! Been living in a world of MSSQL for too long I guess. Quote Link to comment https://forums.phpfreaks.com/topic/293047-unable-to-create-temp-table-in-proc/#findComment-1499415 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.