Re: mysql question
| From: | Man-wai Chang | Date: | Mon, 16 Jul 2007 09:34:25 +0000 |
| Subject: | Re: mysql question | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-258898@lists.php.net to get a copy of this message | ||
> You didn't send much info along, so I assume you're using some version
> of MySQL 5.0.
Thanks. I figured it out (doesn't need 5.0):
CREATE TEMPORARY haha ( KEY (field1), KEY (field2) )
AS
SELECT po_no, po_date, item_no FROM ..... WHERE ....
Then I don't need the privilege for ALTER TABLE.
--
.~. Might. Courage. Vision. Sincerity. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Fedora Core 4) Linux 2.6.17-1.2142_FC4
^ ^ 17:33:02 up 165 days 1:17 1 user load average: 0.03 0.08 0.08