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
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
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
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
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