On a clean installation of the MySQL server (which contains only the databases test and mysql), you select the test database as the default database. Which of the following CREATE TABLE statements will succeed?
A.
CREATE TABLE `my data` (i INT)
B.
CREATE TABLE my data (i INT)
C.
CREATE TABLE my_data (i INT)
D.
CREATE TABLE my.data (i INT)
E.
CREATE TABLE `my.data` (i INT)
The E is correct answer too…As i tested it:
mysql> CREATE TABLE `my.data` (i INT);
Query OK, 0 rows affected (0.16 sec)