试题详情
多项选择题 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

  • D,E

  • 关注下方微信公众号，在线模考后查看

热门试题