Comment Symbols in SQL statements

Comment Symbols in SQL statements Mysql

# to the end of the line 、--to the end of the line and the comment squares:
Mysql> SELECT; # This comment until the end of the line
Mysql> SELECT; --this comment until the end of the line
Mysql> SELECT 1 + 1;
Note--(double length dash) Note style requires at least one space after two long strokes!

Oralce,mssql
Single-line Comment:--Multiline Comment:
Example:
SELECT * from Tb_name; --Check the table of XX record details
SELECT * from Tb_name1;

Comment Symbols in SQL statements