temporary table permissions?

2001-12-20 Thread Paul Chvostek
I've given up on the LEFT JOIN thing I was poking at earlier, and have successfully (at least at a mysql command prompt) designed the necessary sequence of commands to get what I want ... in the form of a CREATE TEMPORARY TABLE follow by two INSERT INTO ... SELECTs. The only catch is ... it

Re: temporary table permissions?

2001-12-20 Thread Carl Troein
Paul Chvostek writes: The only catch is ... it won't go in PHP. The code looks fine, and I suspect it's just a permission problem. Indeed it seems that you need to have CREATE to do that. There might be a good reason for it, but the only thing I can think of is disk usage. Do I *realy*