List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:August 7 2005 7:32pm
Subject:Re: Alter table type/insert_method question
View as plain text  
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 modifications, for options such as ENGINE.
For example:

  ALTER TABLE `BRANCH_mod_user_groups` ENGINE=MyISAM;


Verdon Vaillancourt <vern@stripped> wrote:
> 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 UNION=(HUB_mod_user_groups);
> 
> I'd like to alter it so it is not a merge table, run some other 
> commands on it, and then alter it back to TYPE=MRG_MyISAM 
> INSERT_METHOD=FIRST UNION=(HUB_mod_user_groups)
> 
> Is this do-able? I suspect so from perusing this 
> 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 
> stuff ;) Maybe I'm missing something.
> 
> Thanks,
> verdon
> 
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
Alter table type/insert_method questionVerdon Vaillancourt7 Aug
  • Re: Alter table type/insert_method questionGleb Paharenko8 Aug