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
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
