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;