How do you represent multi-line comments in SQL statements?

12 months ago

Benjamin Taylor

1 minute

In SQL, multi-line comments can be represented using /* and */. Any content between these two symbols will be considered a comment and will not be interpreted as SQL statements. This type of commenting can be used for multi-line comment content. For example:

/*
这是一个多行注释示例
可以跨越多行
*/
SELECT * FROM table_name;

In the example above, /* indicates the start of a comment, and */ indicates the end of a comment. Anything between these symbols will be treated as a comment and will not be executed as an SQL statement.