Re: Alter table type/insert_method question

2005-08-08 Thread Gleb Paharenko
Hello. http://dev.mysql.com/doc/mysql/en/alter-table.html document, but I don't see any examples of altering table types, just a lot of other The syntax for many of the allowable alterations is similar to clauses of the CREATE TABLE statement. This includes table_options

Alter table type/insert_method question

2005-08-07 Thread Verdon Vaillancourt
Hi :) I have a table that is created like such... CREATE TABLE `BRANCH_mod_user_groups` ( `group_id` int(11) NOT NULL default '0', `group_name` varchar(30) default NULL, `description` text, `members` text, PRIMARY KEY (`group_id`) ) TYPE=MRG_MyISAM INSERT_METHOD=FIRST