A

Admin • 802.91K Points
Coach

Q. 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`
  • Correct Answer - Option(B)
  • Views: 1
  • Filed under category MySQL
  • Hashtags:
Explanation by: Admin
This question is about how to correctly reference a table within a database in MySQL. Imagine you have a bookshelf (`sampledb`) and a book (`tbl`) on it. We need to tell MySQL where to find that book.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.