Re: mysql question

Man-wai Chang wrote: > 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? > See the docs. CREATE INDEX syntax: http://dev.mysql.com/doc/refman/5.0/en/create-index.html About privileges: http://dev.mysql.com/doc/refman/5.0/en/grant.html You didn't send much info along, so I assume you're using some version of MySQL 5.0. HTH