Movatterモバイル変換

Standard SQL uses the C syntax/* this is a comment */ for comments, and MySQL Server supports this syntax as well. MySQL also support extensions to this syntax that enable MySQL-specific SQL to be embedded in the comment; seeSection 9.6, “Comments”.

MySQL Server also uses# as the start comment character. This is nonstandard.

Standard SQL also uses“--” as a start-comment sequence. MySQL Server supports a variant of the-- comment style; the-- start-comment sequence is accepted as such, but must be followed by a whitespace character such as a space or newline. The space is intended to prevent problems with generated SQL queries that use constructs such as the following, which updates the balance to reflect a charge:

UPDATE account SET balance=balance-chargeWHERE account_id=user_id

Consider what happens whencharge has a negative value such as-1, which might be the case when an amount is credited to the account. In this case, the generated statement looks like this:

UPDATE account SET balance=balance--1WHERE account_id=5752;

balance--1 is valid standard SQL, but-- is interpreted as the start of a comment, and part of the expression is discarded. The result is a statement that has a completely different meaning than intended:

UPDATE account SET balance=balanceWHERE account_id=5752;

This statement produces no change in value at all. To keep this from happening, MySQL requires a whitespace character following the-- for it to be recognized as a start-comment sequence in MySQL Server, so that an expression such asbalance--1 is always safe to use.