1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Query Error

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

  1. michaelantoi

    michaelantoi New Member

    Joined:
    Aug 13, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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

    Joined:
    Jul 12, 2004
    Messages:
    15,285
    Likes Received:
    364
    Trophy Points:
    83
    You probably need to provide lots of other information like Data format and Query format.
     
  3. Windhan

    Windhan New Member

    Joined:
    Jan 9, 2008
    Messages:
    11
    Likes Received:
    3
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Chennai
    Provide me some more informations like ur csv data formats and the insert statement which u used.
     

Share This Page