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=3Dtmp.article and shop.price=3Dtmp.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/my***********...ie.nctu.edu.tw