On Fri, Jan 31, 2003 at 10:39:13AM +, 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=Inno
At 8:12 + 1/31/03, Jonathan Bedford wrote:
Hi
When creating a table can you use multiple Table_Options?
The O'Reilly "Managing & Using MySQL" show on page 288 a table been created
with two options "...)AUTO_INCREMENT = 1, TYPE=InnoDB;"
The comma should be omitted. You can specify multiple
Hi.
On Fri 2003-01-31 at 10:39:13 +, [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
: When creating a table can you use multiple Table_Options?
:
: The O'Reilly "Managing & Using MySQL" show on page 288 a
: table been created
: with two options "...)AUTO_INCREMENT = 1, TYPE=InnoDB;"
No commas used to seperate multiple options. Here is an example I just
tri
Jonathan,
> 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 = #
Oh