From: Martijn Tonies
Date: March 7 2006 3:46pm
Subject: Re: Merge tables: how to get the "insert_method"?
List-Archive: http://lists.mysql.com/mysql/195491
Message-Id: <0e7701c641fe$5e51de00$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0E74_01C64206.C007EE20"

------=_NextPart_000_0E74_01C64206.C007EE20
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=20
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,
  >=20
  > Anyone got a clue where to get a hold of "insert_method"
  > after creating the table?
  >=20
  > Is the SHOW CREATE TABLE output the only way to
  > get it?
  =20
  >=20

  "insert_method" ??????  =20

  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?=20

  Shawn Green
  Database Administrator
  Unimin Corporation - Spruce Pine=20


------=_NextPart_000_0E74_01C64206.C007EE20--