Thread: Re: [PHP3] alter table

Re: [PHP3] alter table

From

"ÃÖÁø¹é"

Date:

12 June 1999, 03:59:28

Hi.
Thank you for your help.

I used this method

create table cp_guest as
select * from tb_guest;

after drop tb_guest table.
and modify and run this sql.

insert into tb_guest
select * from cp_guest;

Thank you from your help ...

----------
> º¸³½ »ç¶÷: Richard Lynch <lynch@cognitivearts.com>
> ¹Þ´Â »ç¶÷: ÃÖÁø¹é <webmaster@dbinfo.co.kr>
> Á¦¸ñ: Re: [PHP3] alter table
> ³¯Â¥: 1999³â 6¿ù 12ÀÏ Åä¿äÀÏ ¿ÀÈÄ 12:43
>
> You will need to create a new temp table, copy everything into it, drop the
> old one, and rename the new one.
>
> See www.postgresql.org website for precise details.
>
> A search for "alter table" should come up with an example.
>
> >$)CI am sorry. I use the postgreSQL database.
> >----------------------------------------------------------------
> >
> >hi all, I have a problem that is I want to modify ( alter ) this tb_guest
> >table.
> >
> >create table tb_guest (
> > date varchar(8) not null,
> > time varchar(6) not null,
> > name varchar(20) not null,
> > url varchar(25),
> > ip varchar(15),
> > browser varchar(50),
> > email varchar(40),
> > home varchar(50),
> > content varchar(2000)
> >);
> >
> >I want to modify " home varchar(50) " -> "home varchar(80)".
> >Help me, please, solve this problem!
> >Thanks.
> >
> >With Best Regards,
> >CHOI JINBAEK.
> >
> >
> >$)C<html><head></head><BODY bgcolor="#FFFFFF"> >color="#000000" face="1<82">I am sorry. I use the postgreSQL
> >database. --------------------------------------------------------------
> >-- hi all, I have a problem that is I want to modify ( alter ) this
> >tb_guest table. create table  tb_guest  ( 
> >   date     varchar(8)
> >    not null,    time
> >    varchar(6)     not null, 
> >   name     varchar(20) not null, 
> >   url      varchar(25), 
> >   ip       varchar(15), 
> >   browser  varchar(50),    email
> >   varchar(40),    home
> >    varchar(50),    content
> > varchar(2000) ); I want to modify " home varchar(50)
> >" -> "home varchar(80)". Help me, please, solve this
> >problem! Thanks. With Best Regards, CHOI
> >JINBAEK. 
> ></body></html>
>
> -- "TANSTAAFL" Rich lynch@cognitivearts.com webmaster@ and www. all of:
> R&B/jazz/blues/rock - jademaze.com music industry org - chatmusic.com
> acoustic/funk/world-beat - astrakelly.com sculptures - olivierledoux.com
> my own nascent company - l-i-e.com cool coffeehouse - uncommonground.com
>