MySQL: Comments

Profile picture for user arilio666

Why use comments?

  • To explain a query and what it is doing exactly.
  • Or to prevent a query from execution.

These are some of the main factors we use comments for.

Single Line Comment

# or -- is used to comment out a single line of query.

# SELECT * FROM CUSTORDER;
-- select * from movies;

Multiple Line Comment

/* marks the beginning and */ the end of this multiline comment.

/* ALTER TABLE movies RENAME TO movies_list;

select * from movies_list; */

SELECT * FROM Crypto;

Tags