Thread: Using LOAD DATA

  1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    I have a db and wish to load data into it from a tab delimited text file. One of the fields contains price info such 1,234 or 2,423. I am trying to load it into a field of type INT(5). But all I get is the numeral before the column. Everything else gets dropped. Is there an easy way to get this price data into the database or must I eliminate all commas from prices?
  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    Unless I'm mistaken you will have to eliminate all commas from that field if you wish to have the result stored as an int.

  4. #3
  5. No Profile Picture
    Paul Cotton
    Devshed Newbie (0 - 499 posts)
    I have seen a good way of doing this, by converting the , to a . and multiplying by 1000.

Similar Threads

  1. Replies: 0
    Last Post: February 11th, 2004, 02:56 PM
  2. Newbie trying to load data file
    By wab25 in forum Flash Help
    Replies: 2
    Last Post: February 6th, 2004, 04:21 PM
  3. how to load data from excel into C++ Application
    By lenochka in forum C Programming
    Replies: 5
    Last Post: July 10th, 2003, 08:08 AM
  4. load data infile & NOW()
    By saraht28 in forum MySQL Help
    Replies: 0
    Last Post: May 7th, 2003, 06:17 AM
  5. Load data infile and null values
    By joebw in forum MySQL Help
    Replies: 4
    Last Post: February 1st, 2003, 11:22 AM

IMN logo majestic logo threadwatch logo seochat tools logo