Thread: Re: [PHP3] alter table

Re: [PHP3] alter table

From
"ÃÖÁø¹é"
Date:

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 &nbsp;tb_guest &nbsp;(<br>
> >&nbsp;&nbsp;&nbsp;date &nbsp;&nbsp;&nbsp;&nbsp;varchar(8)
> >&nbsp;&nbsp;&nbsp;&nbsp;not null,<br> &nbsp;&nbsp;&nbsp;time
> >&nbsp;&nbsp;&nbsp;&nbsp;varchar(6) &nbsp;&nbsp;&nbsp;&nbsp;not null,<br>
> >&nbsp;&nbsp;&nbsp;name &nbsp;&nbsp;&nbsp;&nbsp;varchar(20) not null,<br>
> >&nbsp;&nbsp;&nbsp;url &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;varchar(25),<br>
> >&nbsp;&nbsp;&nbsp;ip &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;varchar(15),<br>
> >&nbsp;&nbsp;&nbsp;browser &nbsp;varchar(50),<br> &nbsp;&nbsp;&nbsp;email
> >&nbsp;&nbsp;&nbsp;varchar(40),<br> &nbsp;&nbsp;&nbsp;home
> >&nbsp;&nbsp;&nbsp;&nbsp;varchar(50),<br> &nbsp;&nbsp;&nbsp;content
> >&nbsp;varchar(2000)<br>); <br><br>I want to modify &quot; home varchar(50)
> >&quot; -&gt; &quot;home varchar(80)&quot;.<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
>