I want to be able to specify the table type/engine when i create tables in 
mysql.
---------------------------------------------------------------------------------

         Key: DDLUTILS-32
         URL: http://issues.apache.org/jira/browse/DDLUTILS-32
     Project: DdlUtils
        Type: New Feature
    Reporter: Christoffer Hammarström
 Assigned to: Thomas Dudziak 


In MySQL, a table type or engine can be specified after the "create table" 
statement, like so:
CREATE TABLE table
(
    column INTEGER
) ENGINE=InnoDB

"TYPE" is a synonym for "ENGINE".

http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html says "ENGINE is the 
preferred term, but cannot be used before MySQL 4.0.18. TYPE is available 
beginning with MySQL 3.23.0, the first version of MySQL for which multiple 
storage engines were available."


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Reply via email to