Comment Syntax

This document describes the comment syntax supported by TiDB.

TiDB supports three comment styles:

• Use # to comment a line:

  Copy

  SELECT 1+1;     # comments

  +------+
  | 1+1  |
  +------+
  |    2 |
  +------+
  1 row in set (0.00 sec)

• Use -- to comment a line:

  Copy

  SELECT 1+1;     -- comments

  +------+
  | 1+1  |
  +------+
  |    2 |
  +------+
  1 row in set (0.00 sec)

  And this style requires at least one whitespace after --:

  Copy

  SELECT 1+1--1;

  +--------+
  | 1+1--1 |
  +--------+
  |      3 |
  +--------+
  1 row in set (0.01 sec)

• Use /* */ to comment a block or multiple lines:

  Copy

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

  +--------+
  | 1  + 1 |
  +--------+
  |      2 |
  +--------+
  1 row in set (0.01 sec)

  Copy

  SELECT 1+
      -> /*
  /*> this is a
  /*> multiple-line comment
  /*> */
      -> 1;

  +-------+
  | 1+
  1 |
  +-------+
  |     2 |
  +-------+
  1 row in set (0.00 sec)

MySQL-compatible comment syntax

The same as MySQL, TiDB supports a variant of C comment style:

/*! Specific code */

or

/*!50110 Specific code */

In this style, TiDB runs the statements in the comment.

For example:

SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 WHERE ...

In TiDB, you can also use another version:

SELECT STRAIGHT_JOIN col1 FROM table1,table2 WHERE ...

If the server version number is specified in the comment, for example, /*!50110 KEY_BLOCK_SIZE=1024 */, in MySQL it means that the contents in this comment are processed only when the MySQL version is or higher than 5.1.10. But in TiDB, the MySQL version number does not work and all contents in the comment are processed.

TiDB specific comment syntax

TiDB has its own comment syntax (that is, TiDB specific comment syntax) with the format of /*T![feature_id] XXX */. TiDB can parse the SQL fragment in this comment only if it implements the corresponding feature of feature_id in the current version. For example, as the AUTO_RANDOM feature is introduced in v3.1.1, this version of TiDB can parse /*T![auto_rand] auto_random */ into auto_random. Because the AUTO_RANDOM feature is not implemented in v3.0.0, the SQL statement fragment above is ignored.

Optimizer comment syntax

Another type of comment is specially treated as an optimizer hint:

SELECT /*+ hint */ FROM ...;

For details about the optimizer hints that TiDB supports, see Optimizer hints.

Note

In MySQL client before 5.7.7, TiDB specific comment syntax and optimizer comment syntax are treated as comments and cleared by default. To use the two syntaxes in the old client, add the --comments option when you start the client. For example, mysql -h 127.0.0.1 -P 4000 -uroot --comments.

For more information, see Comment Syntax.