1
DROP TABLE IF EXISTS t1;
2
create table t1(a int) engine=myisam;
3
select * into outfile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' from t1;
5
create table t1(a int) engine=ndb;
6
load data local infile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' into table t1;
7
select count(*) from t1;
11
create table t1(a int) engine=myisam;
12
insert into t1 values (1), (2), (2), (3);
13
select * into outfile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' from t1;
15
create table t1(a int primary key) engine=ndb;
16
load data local infile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' into table t1;
17
select * from t1 order by a;
23
create table t1(a int) engine=myisam;
24
insert into t1 values (1), (1), (2), (3);
25
select * into outfile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' from t1;
27
create table t1(a int primary key) engine=ndb;
28
load data local infile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' into table t1;
29
select * from t1 order by a;
35
create table t1(a int) engine=myisam;
36
insert into t1 values (1), (2), (3), (3);
37
select * into outfile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' from t1;
39
create table t1(a int primary key) engine=ndb;
40
load data local infile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' into table t1;
41
select * from t1 order by a;