IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    MySQL 5.6 Database Administrator-066-Which two methods will restore data to the t1 table?

    royalwzy发表于 2015-09-03 03:12:29
    love 0
    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


沪ICP备19023445号-2号
友情链接