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] 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! 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 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! 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] 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. 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'; 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
Archived
This topic is now archived and is closed to further replies.