release/src/router/mysql/mysql-test/suite/rpl/r/rpl_loaddata_m.result

   1 include/master-slave.inc
   2 [connection master]
   3 drop database if exists mysqltest;
   4 USE test;
   5 CREATE TABLE t1(a INT, b INT, UNIQUE(b));
   6 LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE test.t1;
   7 SELECT COUNT(*) FROM test.t1;
   8 COUNT(*)
   9 2
  10 CREATE DATABASE mysqltest;
  11 USE mysqltest;
  12 CREATE TABLE t1(a INT, b INT, UNIQUE(b));
  13 LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE mysqltest.t1;
  14 SELECT COUNT(*) FROM mysqltest.t1;
  15 COUNT(*)
  16 2
  17 SHOW DATABASES;
  18 Database
  19 information_schema
  20 mtr
  21 mysql
  22 mysqltest
  23 test
  24 USE test;
  25 SHOW TABLES;
  26 Tables_in_test
  27 USE mysqltest;
  28 SHOW TABLES;
  29 Tables_in_mysqltest
  30 t1
  31 SELECT COUNT(*) FROM mysqltest.t1;
  32 COUNT(*)
  33 2
  34 DROP DATABASE mysqltest;
  35 DROP TABLE IF EXISTS test.t1;
  36 include/rpl_end.inc