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;
Which two methods will restore data to the t1 table?
A.
Mysql> LOAD DATA INFILE ‘/tmp/t1.sql’ INTO TABLE t1;
B.
$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
C.
$ mysql – u root – p – h localhost test < /tmp/t1.sql
D.
$ mysqlinport – u root – p – h localhost test /tmp/t1.sql
E.
Mysql> INSERT INTO t1 VALUES FROM ‘/tmp/t1.sql’;
答案:AD