On 16 Feb 2004 at 12:46, Bill Marrs wrote: > 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_specification" can be "table_options", and (looking at the "CREATE TABLE" syntax) "table_options" can be a single "table_option", and "table_option" can be "PACK_KEYS = 1". So the syntax is just ALTER TABLE table_name PACK_KEYS = 1; -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
