josh.har1 Posted March 20, 2010 Share Posted March 20, 2010 I tried to import some SQL code into a MySQL database using Xampp and got a nasty error, please tell me if you can help! [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/195947-got-a-nasty-looking-sql-error-s/ Share on other sites More sharing options...
josh.har1 Posted March 20, 2010 Author Share Posted March 20, 2010 Please help! Quote Link to comment https://forums.phpfreaks.com/topic/195947-got-a-nasty-looking-sql-error-s/#findComment-1029265 Share on other sites More sharing options...
jskywalker Posted March 20, 2010 Share Posted March 20, 2010 COMMENTS should be specified another way http://dev.mysql.com/doc/refman/5.1/en/comments.html Quote Link to comment https://forums.phpfreaks.com/topic/195947-got-a-nasty-looking-sql-error-s/#findComment-1029267 Share on other sites More sharing options...
josh.har1 Posted March 20, 2010 Author Share Posted March 20, 2010 COMMENTS should be specified another way http://dev.mysql.com/doc/refman/5.1/en/comments.html Sorry, could you give me an example of what I could put, would much appreciate it! Quote Link to comment https://forums.phpfreaks.com/topic/195947-got-a-nasty-looking-sql-error-s/#findComment-1029272 Share on other sites More sharing options...
josh.har1 Posted March 20, 2010 Author Share Posted March 20, 2010 Got one more error, would really appreciate a look as this one I really don't get... [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/195947-got-a-nasty-looking-sql-error-s/#findComment-1029281 Share on other sites More sharing options...
fenway Posted March 20, 2010 Share Posted March 20, 2010 Please stop posting screenshots for syntax errors -- this is your first & last warning. Also, RTFM -- you need commas between your columns. Quote Link to comment https://forums.phpfreaks.com/topic/195947-got-a-nasty-looking-sql-error-s/#findComment-1029301 Share on other sites More sharing options...
jskywalker Posted March 21, 2010 Share Posted March 21, 2010 i hope you did find out that next code is sufficient to create your table; CREATE TABLE `catalogue_deals` ( `id` INT(10) NOT NULL, -- and if you really need it you can put some comment in it `tid` INT(10) NOT NULL, `amount` INT(10) NOT NULL ) ENGINE = MYISAM DEFAULT CHARSET 'latin1' COLLATE 'latin1_general_ci'; Quote Link to comment https://forums.phpfreaks.com/topic/195947-got-a-nasty-looking-sql-error-s/#findComment-1029564 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.