|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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.
|
|
#3
|
|||
|
|||
|
I have seen a good way of doing this, by converting the , to a . and multiplying by 1000.
|
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > Using LOAD DATA |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|