"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) > Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61 > > How can I see those warnings? > I checked the error log but nothing shows up there. >
From version 4.1.1 you can use SHOW WARNINGS command: http://www.mysql.com/doc/en/SHOW_WARNINGS.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]