Hi.
On Fri 2003-01-31 at 10:39:13 +0000, [EMAIL PROTECTED] wrote:
> Hi
>
> When creating a table can you use multiple Table_Options?
Yes. How about simply trying out beforehand?
> The O'Reilly "Managing & Using MySQL" show on page 288 a table been created
> with two options "...)AUTO_INCREMENT = 1, TYPE=InnoDB;"
>
> But the MySQL manual says "or":-
> table_options:
> TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM }
> or AUTO_INCREMENT = #
> .....
As it does for "create_definition", but that does not mean that you
can only define either a column or a key. The fact that matters is
that one is presented as a list [(create_definition,...)] in the
CREATE TABLE statement, the other is not.
So, yes, the manual is incomplete (especially, because it gives no
indication that you have to seperate the options by comma).
HTH,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
