Home > Database > Mysql Tutorial > body text

How to batch comment sql statements in mysql

王林
Release: 2020-09-02 14:09:57
Original
7722 people have browsed it

How to batch comment SQL statements in mysql: You can use [/* */] to implement batch comments, such as [/*select * from students;*/]. If you want to make a single line comment, you can use [#] or [--].

How to batch comment sql statements in mysql

The specific method is as follows:

(Learning video recommendation: mysql video tutorial)

1 , use "#" to comment

#单行注释
select * from students;
Copy after login

2. Use "-- " to comment

Note: -- is followed by a space

-- MySQL单行注释
select * from students
Copy after login

(Related recommendations: mysql tutorial)

3. Use /* */ for multi-line comments

/*
此处为注释....
*/
select * from students;
Copy after login

The above is the detailed content of How to batch comment sql statements in mysql. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact [email protected]
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!