On Fri, Jan 31, 2003 at 10:39:13AM +0000, Jonathan Bedford wrote:
> Hi
>
> When creating a table can you use multiple Table_Options?
Heh. Why not just try it? :)
> The O'Reilly "Managing & Using MySQL" show on page 288 a table been created
> with two options "...)AUTO_INCREMENT = 1, TYPE=InnoDB;"
No comma is needed.
>
> But the MySQL manual says "or":-
>
> table_options:
> TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM }
> or AUTO_INCREMENT = #
> .....
Hrm. It does not look like we explicitly state that you can use
multiple options anywhere on the CREATE TABLE page in the manual.
I will ask our documentation team to fix it.
Thanks!
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Using and Managing MySQL
MySQL Training: Stuttgart, May 19-23, 2003
Visit http://mysql.com/training for more information
Sincere Choice: Supporting a Fair Software Market (http://sincerechoice.org)
---------------------------------------------------------------------
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
