comments break sql in 3.5/3.51

This topic is empty.

Viewing 3 reply threads

Author

Posts
- June 30, 2003 at 10:05 pm #14614
  
  mhsa
  Member
  
  I noticed the same thing. I think SQLyog strips off the carriage returns, thus MySQL thinks that the statement is all one big long line (instead of the several lines you typed in). Looking at the history pane gives you some idea… When you use an inline comment, MySQL ignores everything after it until the carriage return.
  
  You can only use the C-style comments, /* … */. These will work for in-line comments, and allow you comment out sections in the middle of your statements.
  
  HTH!
- July 8, 2003 at 1:51 pm #14615
  
  Headache
  Member
  
  I have just started working with SQLyog and after one hour of trying to make new databases and tables I suddenly encounter an annoying problem.
  
  I seem to get an error message (No 1064) every time I click the “Insert/Update data” button.
  
  I have deleted the last database and restarted SQLyog! But nothing seems to help.
  
  Can somebody please give me a hint?
- July 8, 2003 at 4:53 pm #14616
  
  Shadow
  Member
  
  Error 1064 corresponds to syntax error meaning you have a flaw in the most recently executed SQL statement. In this case SQLyog may have generated a “bad” INSER/UPDATE command for some of your tables. What version of SQLyog and MySql do you use? What was the table type?
- July 8, 2003 at 6:08 pm #14617
  
  Ritesh
  Member
  
  SQLyog logs every command in the History window.
  
  It will be very helpful if you can paste the SQL statement out here.
Author

Posts