An efficient way to store time is as UNIX_TIMESTAMP (4 bytes) instead of
using DATETIME data type (8 bytes). We were using this technique to save the
time in our database.
Now we need to support millisecond resolution as we need to store data
comming 8 times per second, that is, every 125 millisec
MySQL offers Spacial Extensions to operate with points in a 2 dimensional
space.
For a project I'm working on, I need to work with points in an N dimensional
space and measure the distance among them. Is there a clever do to solve the
following problem?:
Let's say I have 4 3D point (X,Y,Z):
(0,0
I'm working on a system that deals with data with second resolution. The
data type we are using is not the MySQL DATETIME but the MySQL UNSIGNED INT
and we save the datetime as UNIX_TIMESTAMP. By this way we managed to reduce
by 4 bytes the storage needs of each record. We also reduce the index siz
Dear all,
I need SSL support for MySQL. I've checked the documentation and it
seems that for windows there is no SSL support in the binaries. In
addition the documentation in the examples is for Linux.
Has anyone has used MySQL with SSL in windows? If so ... how? How easy
is to set it up? What
tions do not
see your data.
Jose Antonio wrote:
Hi!
I am experiencing something weird using MySQL 4.1.8 with InnoDB tables.
I have an application, let's call it A, that is monitoring the data
that is available in the database. The data is inserted in the
database by a different application,
Hi!
I am experiencing something weird using MySQL 4.1.8 with InnoDB tables.
I have an application, let's call it A, that is monitoring the data that
is available in the database. The data is inserted in the database by a
different application, let's call it B. The problem is the following:
A star
Do you know if I can use MySQL data from MatLab?
Does it exists a connector for MatLab in the same sense as JDBC for Java?
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I need to store huge data series using MySQL with InnoDB as storage
engine. The data type of the parameters can be double, float, int,
smallint, mediumint, tinyint So, I've thought to store them in
the following way:
Table Parameter:
Parameter ID - small int
Parameter Name - varchar(8)
Parame