How to add comments in MySQL?

Question

I want to add a comment to the SQL code. How can i do this? I am using MySQL.

Answer 1

Several ways:

# Comment -- Comment /* Comment */ 

Remember to put a space after -- .

See the documentation .

Answer 2

"You can specify a comment for a column using the COMMENT parameter. The comment is displayed by the SHOW CREATE TABLE and SHOW FULL COLUMNS statements. This parameter works with MySQL 4.1 (it is allowed but ignored in earlier versions.)"

As an example

 -- -- Table structure for table 'accesslog' -- CREATE TABLE accesslog ( aid int(10) NOT NULL auto_increment COMMENT 'unique ID for each access entry', title varchar(255) default NULL COMMENT 'the title of the page being accessed', path varchar(255) default NULL COMMENT 'the local path of teh page being accessed', .... ) TYPE=MyISAM; 

Answer 3

You can use single line comments:

 -- this is a comment # this is also a comment 

Or a multi-line comment:

 /* multiline comment */ 

Answer 4

From here you can use

 # For single line comments -- Also for single line, must be followed by space/control character /* C-style multiline comment */ 

Answer 5

Three types of comments are supported:

• Hashbase single row combination using #

   Select * from users ; # this will list users 

  2. Commenting on Double Dash using -

Select * from users ; -- this will list users

Note. It’s important that immediately after it there is one empty space -

3) Multi-line commenting using / * * /

 Select * from users ; /* this will list users */ 

Answer 6

 /* comment here */ 

here is an example: SELECT 1 /* this is an in-line comment */ + 1;

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