Anda sedang membaca arsip Milis Masterweb (milis-masterweb@yahoogroups.com). Milis ini terbuka untuk setiap praktisi web. Programer web, web designer, sysadmin, dsb. Bergabunglah dengan Masterweb Indonesia (MWI), Komunitas Praktisi Web Tertua & Terbesar di Indonesia! Website: www.master.web.id. Milis: groups.yahoo.com/group/milis-masterweb.

Percayakan hosting website Anda pada PT Masterweb Network (MWN), penyedia hosting yang telah Terpercaya sejak 2000. Dikelola Pakar/Praktisi Web Dan Selalu Terjangkau. 24x7, PHP/MySQL/CGI/ASP/POP/IMAP/dsb. Website: www.masterwebnet.com. Alamat: Cyber Building 10th Floor, Jl. Kuningan Barat 8, Jaksel 10270. Phone: 021-526-9311 (Hunting).

Re: [MasterWeb] SQL

From: Awiyanto Ajisasongko (wyantz@[HIDDEN])
Date: Mon Apr 02 2001 - 14:03:26 WIT

Next message: Dewan Studio: "Re: [MasterWeb] Lowongan Web Developer ,Web Design and Web Maintenance"
Previous message: :: blurmotion: "Re: [MasterWeb] radio indonesia online"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

> 1. Gimana caranya di sql analyzer kita tambahin column misnya saya punya
> column A, B, C di table Z trus saya mau tambahin column D di dlm table Z
> tersebut.
>
alter table Z add D decimal(4)

> 2. trus caranya kita copy column ke column lain
> misalnya saya mau copy isi column A ke column D di table Z tsb
>
update Z set D=A

Awiyanto Ajisasongko
http://redrival.com/wyantz

Next message: Dewan Studio: "Re: [MasterWeb] Lowongan Web Developer ,Web Design and Web Maintenance"
Previous message: :: blurmotion: "Re: [MasterWeb] radio indonesia online"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.5 : Tue Aug 27 2002 - 00:18:44 WIT