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
查看答案
该试题由用户422****50提供
查看答案人数:35380
如遇到问题请
联系客服
正确答案
该试题由用户422****50提供
查看答案人数:35381
如遇到问题请联系客服