How can I add comments in MySQL?

I want to add comment in SQL code. How can I do this? I’m using MySQL.


Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

Several ways:

# Comment
-- Comment
/* Comment */

Remember to put the space after --.

See the documentation.

Method 2

“A comment for a column can be specified with the COMMENT option. The comment is displayed by the SHOW CREATE TABLE and SHOW FULL COLUMNS statements. This option is operational as of 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',

Method 3

You can use single-line comments:

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

Or a multiline comment:


Method 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

Method 5

/* comment here */

Here is an example:

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

Reference: 9.7 Comments

Method 6

Three types of commenting are supported:

  1. Hash base single line commenting using #
    Select * from users ; # this will list users
  2. Double Dash commenting using --
    Select * from users ; -- this will list users

    Note: It’s important to have single white space just after --

  3. Multi line commenting using /* */
    Select * from users ; /* this will list users */

All methods was sourced from or, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes
Article Rating
Notify of

Inline Feedbacks
View all comments
Would love your thoughts, please comment.x