Quiz 2
Quiz yourself on MySQL commands, including DELETE, JOIN, and INDEX.
We'll cover the following...
Question # 1
Q
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
Ask