Re: mysql question
| From: | Man-wai Chang | Date: | Mon, 16 Jul 2007 09:41:08 +0000 |
| Subject: | Re: mysql question | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-258899@lists.php.net to get a copy of this message | ||
> 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.
I meant I could build index on a temp table without
the privilege to use "ALTER TABLE" by making the index
definitions as part of the CREATE TEMPORARY statement.
--
.~. 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:40:01 up 165 days 1:24 1 user load average: 0.02 0.04 0.06