Re: Setting "PACK_KEYS=1" on existing tables

[Dan Nelson]

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