diff options
| author | monty@narttu.mysql.fi <> | 2003-06-04 19:21:51 +0300 |
|---|---|---|
| committer | monty@narttu.mysql.fi <> | 2003-06-04 19:21:51 +0300 |
| commit | 40109c574ac5672a44aa963bbd4c239d1c067deb (patch) | |
| tree | 6b8e47374bf313429416a26678bc409946f34772 /mysql-test/t/loaddata.test | |
| parent | 23145cfed72954c29f5a47e82af22898164be4b0 (diff) | |
| parent | 6217b578b9b9a6f65b6891b888be357d3148f4d0 (diff) | |
| download | mariadb-git-40109c574ac5672a44aa963bbd4c239d1c067deb.tar.gz | |
Merge with 4.0.13
Diffstat (limited to 'mysql-test/t/loaddata.test')
| -rw-r--r-- | mysql-test/t/loaddata.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/loaddata.test b/mysql-test/t/loaddata.test index d7e84590dc0..2f484d30ff7 100644 --- a/mysql-test/t/loaddata.test +++ b/mysql-test/t/loaddata.test @@ -10,4 +10,12 @@ create table t1 (a date, b date, c date not null, d date); load data infile '../../std_data/loaddata1.dat' into table t1 fields terminated by ','; load data infile '../../std_data/loaddata1.dat' into table t1 fields terminated by ',' IGNORE 2 LINES; SELECT * from t1; +truncate table t1; + +load data infile '../../std_data/loaddata1.dat' into table t1 fields terminated by ',' LINES STARTING BY ',' (b,c,d); +SELECT * from t1; drop table t1; + + + + |