I tried to post to mysql.general, but the message never appeared. So I am trying my luck here. How could I build an index for a table created using the "CREATE TEMPORARY TABLE ... SELECT ... FROM ..." syntax, using an account without the privilege to use 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 ^ ^ 16:49:01 up 165 days 33 min 3 users load average: 0.01 0.21 0.30 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php