> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
