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 these
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
s
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(Inqu
lly qualify all column
> names in queries; if so, you should follow your shop standard ;-) More
> likely, you are probably using some sort of query generating tool in which
> case you probably don't have a choice in the matter.
>
> Rhino
>
>
>
> - Original Messag
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 `Produc
