Sql Problem

Discussion in 'Gaming' started by willwill100, Jan 27, 2006.

  1. willwill100

    willwill100 Well-Known Member

    Age:
    32
    Posts:
    231
    Likes Received:
    0
    Joined:
    Nov 6, 2005
    Location:
    Manchester, UK
    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)
     
  2. willwill100

    willwill100 Well-Known Member

    Age:
    32
    Posts:
    231
    Likes Received:
    0
    Joined:
    Nov 6, 2005
    Location:
    Manchester, UK
    BUMPAGE; does no one know the solution?
     
  3. CrimOckie Designs

    CrimOckie Designs Well-Known Member

    Posts:
    900
    Likes Received:
    0
    Joined:
    May 26, 2005
    Location:
    Europe
    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 :)
     

Share This Page