I posted a few days ago, but didn't get any responses. I'm hopeful someone
has seen this, and can offer advice.
We recently converted some tables from MyISAM to InnoDB because the need had
arisen for transactional support.
Things have been fine until recently, when the .frm files for
We have been using MyISAM tables with MySQL merrily for about 18 months.
Recently we upgraded to MySQL 4.1, and even more recently, we converted some
of our MyISAM tables (which needed transactional support) to InnoDB.
After some configuration issues - the worst of which was the need to use a
Michael Stassen wrote:
You would increase your chances of getting a useful answer if you would
take
the time to reformat your query to be easily readable, as I have done for
you below.
SELECT Product.Product,
AssignedToAgent.AgentName AS AssignedTo,
sum(Inquiries) AS
I have an interesting problem that I cannot find any clues to in the MySQL
documentation. The following query works in 3.2.3, but does not work in
4.1.7:
SELECT `Product`.`Product`, `AssignedToAgent`.`AgentName` AS `AssignedTo`,
sum(`Inquiries`) AS `Inquiries` FROM `Inquiry` INNER JOIN
-
From: Geoffrey R. Thompson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, November 23, 2004 12:11 AM
Subject: Alias query problem in 4.1.7?
I have an interesting problem that I cannot find any clues to in the MySQL
documentation. The following query works