db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-32) I want to be able to specify the table type/engine when i create tables in mysql.
Date Wed, 26 Oct 2005 10:54:55 GMT
    [ http://issues.apache.org/jira/browse/DDLUTILS-32?page=comments#action_12355950 ] 

Thomas Dudziak commented on DDLUTILS-32:
----------------------------------------

Sorry, I was out-of-country for a couple of days.
I think I'll add this in the next days as it is useful for other things as well (eg. switching
between unicode and ascii columns for Oracle databases).

> 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
>     Assignee: Thomas Dudziak
>  Attachments: DDLUTILS-32.patch
>
> 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


Mime
View raw message