RE: Question about Table_Options

2003-02-01 Thread Sherzod Ruzmetov
: 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 tried

Re: Question about Table_Options

2003-02-01 Thread Benjamin Pflugmann
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 = 1,

Re: Question about Table_Options

2003-02-01 Thread Paul DuBois
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

Re: Question about Table_Options

2003-02-01 Thread Zak Greant
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=InnoDB;

Question about Table_Options

2003-01-31 Thread Jonathan Bedford
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 |

Question about Table_Options

2003-01-31 Thread Jonathan Bedford
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 |

Re: Question about Table_Options

2003-01-31 Thread Stefan Hinz, iConnect \(Berlin\)
31, 2003 9:12 AM Subject: Question about Table_Options 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