Hi,
The TYPO3 CMS I'm working on uses UTF-8 database fields for some time
now by default. There are sometimes old installation, which have been
updated without properly converting the database. The result: UTF-8
encoded data in (most often) latin1 tables/fields.
I have a conversion script wh
>I would like to create a table with the top 25 Amt_Sold products for
each day
Examples at "Top N per group" at http://www.artfulsoftware.com/queries.php
PB
-
On 5/8/2011 12:21 PM, mos wrote:
I have a table (MyISAM) with summarized Sales data:
Table: ProdSales
Columns:
Sales_Date Date
I have a table (MyISAM) with summarized Sales data:
Table: ProdSales
Columns:
Sales_Date Date,
Product_Code Char(10),
Amt_Sold Double
There are approx 5,000 products sold each day and there are 3 years worth
of data. I would like to create a table with the top 25 Amt_Sold products
for each
Dear MySQL users,
MySQL Community Server 5.1.57, a new version of the popular Open
Source Database Management System, has been released. MySQL 5.1.57
is recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
http://dev.mysql.com/doc/refman/5.1/en/mysql
Hi,
My 2 cents about this inline.
Peter Boros
On 5/6/11 1:50 PM, Reindl Harald wrote:
Am 06.05.2011 13:26, schrieb J M:
Config:
Running on 8G Server.. Currently utilizing 7G.. running only mysql..
[mysqld]
port= 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key
