Which of the following is true regarding the SQL query "query1; # query 2"?
a. Only query 1 will execute
b. Only query 2 will execute
c. Both queries will execute
d. Output will be union of query1 and query 2
Answers
Option a: Only query 1 will execute
Explanation:
In the MySQL server, '#' is one of the symbols that represents a comment line.
As the usage of # before query2 makes '#query2' a comment line, only query1 is executed.
MySQL supports three commenting styles. They are:
"#" represents an end-of-the-line comment.
# Comment goes here.
"--" too represents an end-of-the-line comment and should be followed by at least one space or tab space or newline, etc.
-- Comment goes here.
"/* ... */" represents an inline comment as well as a multi-line comment.
>>>SELECT * /* comment: all the records*/ FROM Employee;
or
/* multiline comment
goes
this */
Learn more:
What are the maximum and the minimum number of rows returned by the R1 right outer join R2?
brainly.in/question/21195376
Write SQL commands for (a) to (e) on the basis of FAMILY relation given below:
brainly.in/question/15115256