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"><p><font size=2
> >color="#000000" face="1<82">I am sorry. I use the postgreSQL
> >database.<br>--------------------------------------------------------------
> >--<br><br>hi all, I have a problem that is I want to modify ( alter ) this
> >tb_guest table.<br><br>create table tb_guest (<br>
> > date varchar(8)
> > not null,<br> time
> > varchar(6) not null,<br>
> > name varchar(20) not null,<br>
> > url varchar(25),<br>
> > ip varchar(15),<br>
> > browser varchar(50),<br> email
> > varchar(40),<br> home
> > varchar(50),<br> content
> > varchar(2000)<br>); <br><br>I want to modify " home varchar(50)
> >" -> "home varchar(80)".<br>Help me, please, solve this
> >problem!<br>Thanks.<br><br>With Best Regards, <br>CHOI
> >JINBAEK.<br><br><br></p>
> ></font></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
>