Re: Merge tables: how to get the "insert_method"?

[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, Firebird, MySQL, Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
  "Martijn Tonies" <m.tonies@stripped> 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?
   
  > 

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

  Shawn Green
  Database Administrator
  Unimin Corporation - Spruce Pine