RE: Column type problem

Subject: Re: Column type problem As seen in manual there's no exact data type for your kind of data: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-type-overview.html see also: http://dev.mysql.com/doc/refman/5.0/en/column-types.html so you can: 1. Use 1 timestamp column and 1 INT column just

Re: Column type problem

As seen in manual there's no exact data type for your kind of data: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-type-overview.html see also: http://dev.mysql.com/doc/refman/5.0/en/column-types.html so you can: 1. Use 1 timestamp column and 1 INT column just for milliseconds 2. Use BIGINT

Column type problem

Title: Column type problem 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

column type problem

Hi , I using MySql from Visual Foxpro cross over ODBC 3.51 . When I run a SELECT statement then the DECIMAL 15,0 MySql field arrived to Foxpro as Currency type with 4 digits decimals! The data not lost (15 digits long) but ,the decimals set to 4 and column type is Currency . I must always

Fw: column type problem

Hi , More column type problem ...The MySql Text fields arrived as General (not readable) field in VFP via ODBC... By: Zoltan - Original Message - From: Szmutku Zoltán To: mysql@lists.mysql.com Sent: Monday, October 24, 2005 10:36 AM Subject: column type problem Hi , I using