多选题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 –
题目
多选题
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
相似考题
参考答案和解析
正确答案：
A,B
解析：
暂无解析