Thank you very much for your reply.
now, I find how to set these parameter correctly. So I place these
parameter in __table_args__ and it works!
__table_args__ = {'mysql_charset': 'utf8', 'mysql_engine': 'InnoDB',
'mysql_collate': 'utf8_general_ci',
'mysql_row_format': 'COMPRESSED',
'mysql_key_block_size': '4'}
Michael Bayer於 2014年2月16日星期日UTC+8上午9時25分30秒寫道：
>
> Guess this is MySQL. The MySQL dialect accepts open ended argument names
> within Table:
>
> t = Table('t', m, Column('q', Integer),
> mysql_key_block_size="50",
> mysql_row_format='COMPRESSED'
> )
>
> e = create_engine("mysql://scott:tiger@localhost/test", echo=True)
> t.create(e)
>
>
> the doc section isn’t named terrifically but its mentioned here:
>
> http://docs.sqlalchemy.org/en/rel_0_9/dialects/mysql.html#storage-engines
>
>
>
> On Feb 15, 2014, at 11:56 AM, DoDo <samte...@gmail.com <javascript:>>
> wrote:
>
> Hello all,
>
> May I know the way to declare the 'row_foramt' and 'key_block_size' during
> table creation?
> The parameter I'd like to use:
>
> ROW_FORMAT=compressed
> KEY_BLOCK_SIZE=8
>
> Thank you.
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sqlalchemy+...@googlegroups.com <javascript:>.
> To post to this group, send email to sqlal...@googlegroups.com<javascript:>
> .
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
