移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

多选题

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;

发布日期:2022-07-07

In a test database, you issue the SELECT … INTO OU...
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

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!