1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

how to create innodb database in mysql

Discussion in 'MySQL' started by look4guna, Jan 9, 2011.

  1. #1
    Hi friends,
    i want to create database type as innodb. searched in web but only ended up with creating tables as innodb. if i set to db as innodb type then all tables will be created that type , no need to create each table as this type.

    so can any one tell me what is the command to create database as innodb type, i used following but got error

    CREATE DATABASE "mydd" ENGINE = InnoDB
     
    look4guna, Jan 9, 2011 IP
  2. jkl6

    jkl6 Peon

    Messages:
    70
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Take a look at this link
     
    jkl6, Jan 10, 2011 IP
  3. look4guna

    look4guna Active Member

    Messages:
    60
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #3
    thanks jkl6. But am creating a tool that used to create db with predefined tables, so i dont hav the knowledge of users default storage engine. thats why i tried to set this database as
    Innodb. how to make it?
     
    look4guna, Jan 10, 2011 IP