Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   MySQL Query Error (http://www.go4expert.com/forums/mysql-query-error-t5824/)

michaelantoi 13Aug2007 05:46

MySQL Query Error
I'm trying to import a .csv file into my mysqldb. I keep getting this error:

Data truncated for column 'column_name' at row 1

Can someone please explain why this is happening?

I even changed all the values in that column to a simple '1' value and I still get this error.

shabbir 13Aug2007 08:51

Re: MySQL Query Error
You probably need to provide lots of other information like Data format and Query format.

Windhan 10Jan2008 12:55

Re: MySQL Query Error
Provide me some more informations like ur csv data formats and the insert statement which u used.

All times are GMT +5.5. The time now is 14:06.