A statement exists that can duplicate the definition of the ‘world’table.
What is missing?
CREATE TABLE t1 ___________world
A.
FROM
B.
USING
C.
COPY
D.
LIKE
What is missing?
A statement exists that can duplicate the definition of the ‘world’table.
What is missing?
CREATE TABLE t1 ___________world
correct is D
REATE TABLE newtable LIKE oldtable;// creating the table
INSERT newtable SELECT * FROM oldtable;// Inserting into newtable
CREATE TABLE newtable LIKE oldtable;// creating the table
INSERT newtable SELECT * FROM oldtable;// Inserting into newtable
————-
C
D
From MySQL 5.0 Certification Study Guide by Dubois, Hinz, and Pedersen:
“Using the LIKE keyword with CREATE TABLE creates an empty table based on the definition of another table.”
D
D