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
30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Jonathan Bedford" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 31, 2003 9:12 AM
Subject: Question about Table_Options
> Hi
>
> When creating a table can you use multiple Table_
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;"
But the MySQL manual says "or":-
table_options:
TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE |
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;"
But the MySQL manual says "or":-
table_options:
TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE |
