Comments in MySQL

0 votes
Hi!!

Can someone tell me how to mention comments in MySQL?
Nov 26, 2018 in Database by darklord
• 6,140 points
81 views

1 answer to this question.

0 votes

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;
answered Nov 26, 2018 by DataKing99
• 8,130 points

Related Questions In Database

0 votes
1 answer

Types of tables in MySQL

MyISAM is the default table that is ...READ MORE

answered Aug 21, 2018 in Database by CodingByHeart77
• 3,680 points
88 views
0 votes
1 answer

TRIGGERS used in MySQL tables

The following TRIGGERS are allowed in MySQL:  BEFORE ...READ MORE

answered Aug 21, 2018 in Database by CodingByHeart77
• 3,680 points
24 views
0 votes
1 answer

Accessing connection from different class in Java / MySQL?

You should just instantiate DoComms with every ...READ MORE

answered Nov 14, 2018 in Database by nirvana
• 3,060 points
37 views
0 votes
1 answer

What is HAVING Clause in MySQL?

Since the WHERE keyword cannot be used with aggregate ...READ MORE

answered Nov 21, 2018 in Database by darklord
• 6,140 points
39 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,130 points
42 views
0 votes
1 answer

Find values in a comma separated string in a MySQL query

You can add commas to the left and ...READ MORE

answered Sep 10, 2018 in Database by darklord
• 6,140 points
1,889 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by darklord
• 6,140 points
235 views
0 votes
1 answer
0 votes
1 answer

Aggregate Functions in MySQL

The aggregate functions are as follows: MIN() Function This ...READ MORE

answered Nov 26, 2018 in Database by DataKing99
• 8,130 points
47 views
+1 vote
1 answer

What are the data types in MySQL?

The Data Types of MySQL are as ...READ MORE

answered Dec 12, 2018 in Database by DataKing99
• 8,130 points
48 views