1
by brian
clean slate |
1 |
SET SESSION STORAGE_ENGINE = InnoDB; |
2 |
drop table if exists t1; |
|
707
by Brian Aker
Enabling loaddata_autocom_innodb |
3 |
create table t1 (id int not null auto_increment primary key, a text, b text); |
1
by brian
clean slate |
4 |
start transaction; |
5 |
load data infile '../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by '''' (a, b); |
|
6 |
commit;
|
|
7 |
select count(*) from t1;
|
|
8 |
count(*)
|
|
707
by Brian Aker
Enabling loaddata_autocom_innodb |
9 |
3
|
1
by brian
clean slate |
10 |
truncate table t1;
|
11 |
start transaction;
|
|
12 |
load data infile '../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by '''' (a, b);
|
|
13 |
rollback; |
|
14 |
select count(*) from t1; |
|
15 |
count(*) |
|
16 |
0
|
|
17 |
drop table t1; |