Sql Problem

Code:

CREATE TABLE `temp` (
`Competitor` VARCHAR( 12 ) NOT NULL ,
`two` VARCHAR( 12 ) NOT NULL ,
`three` VARCHAR( 12 ) NOT NULL 
) 

SELECT Competition Name FROM Competitions

UPDATE table_name
SET table_name = 'Competition Name'

Okay, I just want to create several tables with the same name as what is in the column Competition Name which is in the Competitions table.

This code gives me errors, can any 1 give me a hand??

(im a noob, so dont be harsh at my ignorance lol)

 

BUMPAGE; does no one know the solution?

 

cant help you with this, sorry m8...
did you ask your host?
i used to have some problems with my SQL, my host back then resolved them in 2 minutes