Which of the following CREATE TABLE statements will succeed?

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?

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)



Leave a Reply 0

Your email address will not be published. Required fields are marked *