distal-attribute
distal-attribute
distal-attribute
distal-attribute

annotation proposal

User, date Message
Written by husted
2 years ago
Category: General
4 posts since Fri, 02 Mar 12
the annotation in the heidisql query editor has to be written like the following way:
-- select * from...
namely,there must be a blank space after --,otherwise, if i enter
--select * from...,no blank space between -- and select,when execute this sql statement,the ide report error as follows:

"SQL Error(1064),You have an error in your SQL syntax; check the manual that corresponds to your mysql server version......"

while in the Microsoft sql server management studio,the two way are all right.


i think this should be fix in the heidisql ide.
Written by kalvaro
2 years ago
593 posts since Thu, 29 Nov 07
Well, that's the syntax for MySQL's SQL dialect. HeidiSQL should not deviate from it; otherwise, it'd be crazy.

http://dev.mysql.com/doc/refman/5.5/en/comments.html

«MySQL Server supports three comment styles:

- From a “#” character to the end of the line.

- From a “-- ” sequence to the end of the line. In MySQL, the “-- ” (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character (such as a space, tab, newline, and so on). This syntax differs slightly from standard SQL comment syntax, as discussed in Section 1.8.5.5, “'--' as the Start of a Comment”.

- From a /* sequence to the following */ sequence, as in the C programming language. This syntax enables a comment to extend over multiple lines because the beginning and closing sequences need not be on the same line.»
 

Please login to leave a reply, or register at first.