Quiz 2
Quiz yourself on MySQL commands, including DELETE, JOIN, and INDEX.
We'll cover the following...
We'll cover the following...
Question # 1
1.
Consider we have two tables A and B each with one only one column.
Table A
| ID |
|---|
| 1 |
| 5 |
Table B
| Name |
|---|
| Alex |
| John |
What will be the output of running the below query:
DELETE A, B FROM A, B WHERE A.id in (-7);
A.
None of the data is deleted
B.
Data from both the tables is deleted
C.
Data from table B is deleted but not from table A
1 / 1