CREATE mysql database with default InnoDB tables?
Posted
by memilanuk
on Stack Overflow
See other posts from Stack Overflow
or by memilanuk
Published on 2010-06-16T03:12:30Z
Indexed on
2010/06/16
3:22 UTC
Read the original article
Hit count: 344
Hello,
I've been working on writing a SQL statement to create a MySQL database with several default options, including default character set and default collate. Is it possible to add syntax to make the default engine type for tables in this database to be innodb? I've been looking through the MySQL manual for v.5.1 and I've found the statement 'ENGINE=innodb' which would be appended to a CREATE TABLE statement... but I haven't found anything related to a CREATE DATABASE statement. Is there a normal way to do this as part of the database creation, or does it need to be specified on a table-by-table basis?
Thanks,
Monte
© Stack Overflow or respective owner