I am trying to create a table to import data on cpu usage based on certain programs. the following is a sample of the data..... When I import into the tables their is no field type that matches up to this type of time data. The field type (time) is close to it but it drops of the :nn. Is their some way around this? or I'm just out of luck.
Job time(format(hour:min:sec.nn))
-------------------- -----------------------------------------------------
APPLRASI 01:18.9
APPLRCTL 22.9
APPLRCUS 08:05.0
APPLRDLE 26.99
APPLRDLS 53.3
ARST831S 22.12
BAPP0001 4.36
BAPP0004 5.57
BAPP0005 8.01
BAPP0006 5.1
BAPP0007 23.02
BAPP0008 2.35
Lance Longstreth
Bandag Inc
GITS Infrastructure Security and Engineering
zOS systems/Linux
[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
