Victoria Reznichenko wrote:
[EMAIL PROTECTED] wrote:
mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO
TABLE quantis_mkr;
Query OK, 271392 rows affected (4 min 2.95 sec)
Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
How can I see those warnings?
I checked the error log but not
[EMAIL PROTECTED] wrote:
>> > mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO
>> TABLE quantis_mkr;
>> > Query OK, 271392 rows affected (4 min 2.95 sec)
>> > Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
>> >
>> > How can I see those warnings?
>> > I checked the error log but
> > mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO
> TABLE quantis_mkr;
> > Query OK, 271392 rows affected (4 min 2.95 sec)
> > Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
> >
> > How can I see those warnings?
> > I checked the error log but nothing shows up there.
> >
>
"Tuncay Baskan (Yaz.Muh.-Proje Gel.ve Uyg.Gr.)" <[EMAIL PROTECTED]> wrote:
> When I run LOAD DATA it sometimes notices that there were some warnings. For example;
>
> mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO TABLE quantis_mkr;
> Query OK, 271392 rows affected (4 min 2.95 sec)
>
When I run LOAD DATA it sometimes notices that there were some warnings. For example;
mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO TABLE quantis_mkr;
Query OK, 271392 rows affected (4 min 2.95 sec)
Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
How can I see those warnings?
On 15 Aug 2002, at 10:45, Brian Fahey wrote:
> How do I find out what the warnings are? I haven't been able to find
> anything about what they are.
Paul DuBois has a Perl script, load_diag.pl, that could answer your
question:
http://www.kitebird.com/mysql-cookbook/
Or you could export the d
I have been using the following code and have been getting warnings:
LOAD DATA INFILE 'myfile' INTO TABLE mytable FIELDS TERMINATED BY
'\t' LINES TERMINATED BY '\n' (myfields);
Query OK, 206 rows affected (0.13 sec)
Records: 206 Deleted: 0 Skipped: 0 Warnings: 14
How do I find out what the
I have been using the following code and have been getting warnings:
LOAD DATA INFILE 'myfile' INTO TABLE mytable FIELDS TERMINATED BY
'\t' LINES TERMINATED BY '\n' (myfields);
Query OK, 206 rows affected (0.13 sec)
Records: 206 Deleted: 0 Skipped: 0 Warnings: 14
How do I find out what the