Merge tables: how to get the insert_method?

2006-03-07 Thread Martijn Tonies
Hi, Anyone got a clue where to get a hold of insert_method after creating the table? Is the SHOW CREATE TABLE output the only way to get it? Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts:

Re: Merge tables: how to get the insert_method?

2006-03-07 Thread SGreen
Martijn Tonies [EMAIL PROTECTED] wrote on 03/07/2006 09:57:17 AM: Hi, Anyone got a clue where to get a hold of insert_method after creating the table? Is the SHOW CREATE TABLE output the only way to get it? Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL,

Re: Merge tables: how to get the insert_method?

2006-03-07 Thread Martijn Tonies
Hello Shawn, Thanks for replying. INSERT_METHOD is an option valid for merge tables. See http://dev.mysql.com/doc/refman/5.0/en/create-table.html From what I can see, the only way to get it, is parse the SHOW CREATE TABLE output. Martijn Tonies Database Workbench - tool for InterBase,

Re: Merge tables: how to get the insert_method?

2006-03-07 Thread Felix Geerinckx
On 07/03/2006, [EMAIL PROTECTED] wrote: insert_method ?? I thought I knew a little about databases and table design but that's a new term for me. What does it mean and how would I apply it in order to modify a table's contents? From

Re: Merge tables: how to get the insert_method?

2006-03-07 Thread SGreen
Martijn Tonies [EMAIL PROTECTED] wrote on 03/07/2006 10:46:58 AM: Hello Shawn, Thanks for replying. INSERT_METHOD is an option valid for merge tables. See http://dev.mysql.com/doc/refman/5.0/en/create-table.html From what I can see, the only way to get it, is parse the SHOW CREATE