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.
     
    michaelantoi, Aug 13, 2007
    SHARE #1
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    You probably need to provide lots of other information like Data format and Query format.
     
    shabbir, Aug 13, 2007
    SHARE #2
  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.
     
    Windhan, Jan 10, 2008
    SHARE #3

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice