From: Dan Nelson
Date: February 16 2004 5:57pm
Subject: Re: Setting "PACK_KEYS=1" on existing tables
List-Archive: http://lists.mysql.com/mysql/159773
Message-Id: <20040216175725.GG15700@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Feb 16), Bill Marrs said:
> Is there a way to set "PACK_KEYS=1" on existing tables without doing a dump 
> and load?
> 
> I didn't find it in the "ALTER TABLE" syntax.

It's there:

   ALTER [IGNORE] TABLE tbl_name alter_specification [, alter_specification ...]

     alter_specification:
...
       | table_options

It's a table option.  They're detailed in the CREATE TABLE syntax
description.

-- 
	Dan Nelson
	dnelson@stripped