Hello.
Send an example of your file and your table's definition (use SHOW CREATE TABLE for this purpose). Please, next time send your replies to the list. > >Hope you're doing great today. Back to my question last week, I've >been encountering this problem of loading my file using the "load data >local infile" command for a particular text file. > >I cannot determine the error in my sql codes since i find no problem >loading other text file into the database. > > mysql> load data local infile 'syslog5.txt' into table log4 fields > >>> >> >>>> > terminated by ' \t' lines terminated by '\n'; >> >>> >> >>>> > Query OK, 2 rows affected, 513 warnings (0.03 sec) >> >>> >> >>>> > Records: 20 Deleted: 0 Skipped: 18 Warnings: 505 > > >I'm not familiar with this "warnings" myself. I can only load the >first line in the "syslog5.txt" and the rest are ignored. From the two >rows only the first line is stored and the rest are ignored. > >The result of my select statement from the log4 table includes all >null value on the first row and the value of the second line for the >second row. > >Would appreciate if you can teach me how to debug the warning or maybe >enlighten me on the cause of the problem. > >Thanks for all your help. > >Elizabeth > >On 6/24/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > >>> Hello. >>> >>> >>> >>> What 'SHOW WARNINGS' reports? Elizabeth Bonifacio <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]