Comments in MySQL

Question

Hi!!

Can someone tell me how to mention comments in MySQL?

Answer 1

Like any other programming language, there are mainly two types of comments.

Single-Line Comments – The single line comments start with ‘–‘. So, any text mentioned after — till the end of the line will be ignored by the compiler.

Example:

--Select all: SELECT * FROM Students;

Multi-Line Comments – The Multi-line comments start with /* and end with */. So, any text mentioned between /* and */ will be ignored by the compiler.

Example:

/*Select all the columns of all the records in the Students table:*/ SELECT * FROM Students;