|
1
by brian
clean slate |
1 |
SET SESSION STORAGE_ENGINE = InnoDB; |
2 |
drop table if exists t1; |
|
3 |
create table t1 (id int unsigned not null auto_increment primary key, a text, b text); |
|
4 |
start transaction; |
|
5 |
load data infile '../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by '''' (a, b); |
|
6 |
Warnings:
|
|
7 |
Warning 1261 Row 3 doesn't contain data for all columns
|
|
8 |
commit;
|
|
9 |
select count(*) from t1;
|
|
10 |
count(*)
|
|
11 |
4
|
|
12 |
truncate table t1;
|
|
13 |
start transaction;
|
|
14 |
load data infile '../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by '''' (a, b);
|
|
15 |
Warnings: |
|
16 |
Warning 1261 Row 3 doesn't contain data for all columns |
|
17 |
rollback; |
|
18 |
select count(*) from t1; |
|
19 |
count(*) |
|
20 |
0
|
|
21 |
drop table t1; |