how i add a new table in mysql

Discussion in 'MySQL' started by ironmankho, Mar 2, 2009.

  1. #1
    hence i am newbie in mysql ...please give me hint how it is possible to do this

    [​IMG]
     
    ironmankho, Mar 2, 2009 IP
  2. basia

    basia Well-Known Member

    Messages:
    263
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    155
    #2
    Go to the SQL tab and type in create table query. Here's an example:

    CREATE TABLE example(
    id INT NOT NULL AUTO_INCREMENT,
    PRIMARY KEY(id),
    name VARCHAR(30),
    age INT)
     
    basia, Mar 2, 2009 IP
  3. nirajkum

    nirajkum Active Member

    Messages:
    815
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    #3
    I think you are using phpadmin ..... go to the database tab .. at the top you will find an option to create a table
     
    nirajkum, Mar 2, 2009 IP
  4. ironmankho

    ironmankho Active Member

    Messages:
    393
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    55
    #4
    Thanks for code ...and thanks for hint ..yes i am using phpmyadmin .....
     
    ironmankho, Mar 3, 2009 IP