We are looking for some help with queries that will accomplish a similar
feature to what Amazon does. When you purchase a product, Amazon looks at
all other people who have purchased that product, and then looks at all of
the OTHER products those people have purchased, and uses that data to
suggest
Greetings all,
We are migrating our web site from one server to another and are
having some issues with transferring our MySQL database. Here's the
process we're currently using:
1) run mysqldump for each table in our database (i.e. one file for each table)
2) compress each file using gzip
3) tra
We have a table that has two datetime fields (start_time and
end_time). We'd like to be able to calculate the number of seconds
between these two fields in a query. However, a simple "end_time -
start_time" does not yield a correct result.
SELECT start_time, end_time, end_time - start_time FROM
ma
be greatly appreciated!
Hardware: Cobalt RaQ550, 1 GB RAM, dual (fast) proc MySQL version 3.23.38
Thank You,
Brian Erickson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
