import 'decimal' data to int(11)

2003-02-15 Thread Tim Johnson
Hello All: using MYSQL Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) (RH 7.2) I have data exported from an excel spreadsheet as tab delimited text. Certain columns need to go to mysql table columns with a type of int(11). (alternative datatypes will be considered)

Re: import 'decimal' data to int(11)

2003-02-15 Thread Paul DuBois
At 9:05 -0900 2/15/03, Tim Johnson wrote: Hello All: using MYSQL Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) (RH 7.2)    I have data exported from an excel spreadsheet as tab delimited text. Certain columns need to go to mysql table columns with a type of int(11).