Which of the following MySQL statements is valid if `sampledb` is a database and `tbl` is a table in it?

Question

Which of the following MySQL statements is valid if  `sampledb`  is a database and  `tbl`  is a table in it?

TuteeHUB · Accepted Answer

SELECT * FROM `member`.`sampledb`

TuteeHUB · Answer

SELECT * FROM `sampledb.member`

TuteeHUB · Answer

SELECT * FROM `sampledb`.`member`

TuteeHUB · Answer

SELECT * FROM `member`.`sampledb`

TuteeHUB · Answer

SELECT * FROM `member.sampledb`

1.	Which of the following MySQL statements is valid if `sampledb` is a database and `tbl` is a table in it?
A.	SELECT * FROM `sampledb.member`
B.	SELECT * FROM `sampledb`.`member`
C.	SELECT * FROM `member`.`sampledb`
D.	SELECT * FROM `member.sampledb`
Answer» C. SELECT * FROM `member`.`sampledb`

Discussion