ndb_loaddatalocal.result 1.39 KB
Newer Older
1 2
DROP TABLE IF EXISTS t1;
create table t1(a int) engine=myisam;
unknown's avatar
unknown committed
3
select * into outfile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' from t1;
4 5
drop table t1;
create table t1(a int) engine=ndb;
unknown's avatar
unknown committed
6
load data local infile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' into table t1;
7 8 9 10 11 12
select count(*) from t1;
count(*)
10000
drop table t1;
create table t1(a int) engine=myisam;
insert into t1 values (1), (2), (2), (3);
unknown's avatar
unknown committed
13
select * into outfile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' from t1;
14 15
drop table t1;
create table t1(a int primary key) engine=ndb;
unknown's avatar
unknown committed
16
load data local infile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' into table t1;
17 18 19 20 21 22 23 24
select * from t1 order by a;
a
1
2
3
drop table t1;
create table t1(a int) engine=myisam;
insert into t1 values (1), (1), (2), (3);
unknown's avatar
unknown committed
25
select * into outfile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' from t1;
26 27
drop table t1;
create table t1(a int primary key) engine=ndb;
unknown's avatar
unknown committed
28
load data local infile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' into table t1;
29 30 31 32 33 34 35 36
select * from t1 order by a;
a
1
2
3
drop table t1;
create table t1(a int) engine=myisam;
insert into t1 values (1), (2), (3), (3);
unknown's avatar
unknown committed
37
select * into outfile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' from t1;
38 39
drop table t1;
create table t1(a int primary key) engine=ndb;
unknown's avatar
unknown committed
40
load data local infile 'MYSQLD_DATADIR/ndb_loaddatalocal.select_outfile' into table t1;
41 42 43 44 45 46
select * from t1 order by a;
a
1
2
3
drop table t1;