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=Inno

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 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

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 tri

Re: Question about Table_Options

2003-01-31 Thread Stefan Hinz, iConnect \(Berlin\)
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