Commenting

[chrisgarvey]

Hi I'm just starting to learn mysql for the first time.

I know in Oracle SQL*Plus you add comments to your code using the REM statement.

How can you add comments in mysql?

Cheers,

Chris.

 

[rzs0502]

#Comments are preceded by a hash

"If you always do what you've always done, you will always be where you've always been."

 

[TonyGroves]

As well as using # for end-of-line comments, you can also use /* ... */ for embedded comments. For example:

[tt]SELECT userid[/tt] /* the user's id */[tt], username[/tt] # the user's name
[tt]FROM userstable[/tt]

-----
ALTER world DROP injustice, ADD peace;