1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

MySQL Query Error

Discussion in 'MySQL' started by michaelantoi, Aug 13, 2007.

  1. michaelantoi

    michaelantoi New Member

    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.
     
  2. shabbir

    shabbir Administrator Staff Member

    You probably need to provide lots of other information like Data format and Query format.
     
  3. Windhan

    Windhan New Member

    Provide me some more informations like ur csv data formats and the insert statement which u used.
     

Share This Page