In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE /tmp/t1.sql from t1; mysql＞ TRUNCATE t1;A.$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sqlB.Mysql＞ INSERT INTO t1 VALUES FROM /tmp/t1.sqlC.$ mysql – u root – p – h localhost test ＜ /tmp/t1.sqlD.Mysql＞ LOAD DATA INFILE /tmp/t1.sql INTO TABLE t1E.$ mysqlinport – u root – p

多项选择题

In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（）
Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1;
mysql＞ TRUNCATE t1;

A.$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
B.Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
C.$ mysql – u root – p – h localhost test ＜ /tmp/t1.sql
D.Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
E.$ mysqlinport – u root – p – h localhost test /tmp/t1.sql

1z0-883