diff options
| author | monty@mashka.mysql.fi <> | 2003-05-22 02:57:27 +0300 |
|---|---|---|
| committer | monty@mashka.mysql.fi <> | 2003-05-22 02:57:27 +0300 |
| commit | cb7061ebe40e3a32023db4b4b89db9e46df8ceec (patch) | |
| tree | ed5eeb9e58454d28807426e58e1c1c16e4c08de4 /mysql-test/r/loaddata.result | |
| parent | 8d52377a5c7ac1880fba575056a8fa87feff00d8 (diff) | |
| parent | 6aa8929cf37374fe74c31eb03007961fa119213a (diff) | |
| download | mariadb-git-cb7061ebe40e3a32023db4b4b89db9e46df8ceec.tar.gz | |
merge
Diffstat (limited to 'mysql-test/r/loaddata.result')
| -rw-r--r-- | mysql-test/r/loaddata.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/loaddata.result b/mysql-test/r/loaddata.result new file mode 100644 index 00000000000..d121a4e6c40 --- /dev/null +++ b/mysql-test/r/loaddata.result @@ -0,0 +1,11 @@ +drop table if exists t1; +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; +a b c d +0000-00-00 NULL 0000-00-00 0000-00-00 +0000-00-00 0000-00-00 0000-00-00 0000-00-00 +2003-03-03 2003-03-03 2003-03-03 NULL +2003-03-03 2003-03-03 2003-03-03 NULL +drop table t1; |