I am attempting to create a temporary table to do a complex query and I get an error:
error 1044: Access denied for user: '@localhost' to database 'shopsample'
what can I do to keep this from happening? I am using the production version of mySQL
4.0.13 in windows 2000.
Here is the query:
create temporary table tmp (
article int(4) unsigned zerofill default '0000' not null,
price double(16,2) default '0.00' not null);
the goal is to continue to the following:
lock tables shop read;
insert into tmp select article, max(price) from shop group by article;
select shop.article, dealer, shop.price from shop, tmp
where shop.article=tmp.article and shop.price=tmp.price;
unlock tables;
drop table tmp;
Any assistance would be appreciated.
George
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
