: Problem with Temporary Table
Didier ROS [EMAIL PROTECTED] wrote:
I am a newbie
I want to create a temporary table and I get the following error
message :
mysql CREATE TEMPORARY TABLE tempemp AS SELECT * FROM emp;
ERROR 1044: Access denied for user: '@localhost' to database 'test1
Didier ROS [EMAIL PROTECTED] wrote:
I am a newbie
I want to create a temporary table and I get the following error
message :
mysql CREATE TEMPORARY TABLE tempemp AS SELECT * FROM emp;
ERROR 1044: Access denied for user: '@localhost' to database 'test1'
You must have CREATE
It's probably a matter of granting CREATE TEMPORARY TABLE privilege for the
hardware user.
HTH,
Lian
-Original Message-
From: Andrey Mishenin [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 8:26 PM
To: [EMAIL PROTECTED]
Subject: Problem using TEMPORARY TABLE
I've got a
Andrey Mishenin [EMAIL PROTECTED] wrote:
I've got a problem using temporary tables. Tring to make one (mysql CREATE
TEMPORARY TABLE ... ) I recieve an error message:
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'hardware'
At the mean