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 Link to comment https://forums.phpfreaks.com/topic/293047-unable-to-create-temp-table-in-proc/ Share on other sites More sharing options...
requinix Posted December 11, 2014 Share Posted December 11, 2014 DECLAREs have to come before everything else. 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! 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. 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
Archived
This topic is now archived and is closed to further replies.