BTW misalkan di table_2 kita tambahkan data baru -> 3 brarti juga
harus diberikan event trigger untuk menginputkan ke table_3 untuk
record baru (3) pada table_2 terhadap table_1, apakah harus diberikan
event trigger disetiap table nya ?
example
table_1
nama
A
B
table_2
Data
1
2
3 <- data baru
table_3
nama data
A 1
A 2
B 1
B 2
A 3
B 3
mohon pencerahan, thx before
--- In [email protected], "Sistyo Alfan Tribowo"
<[EMAIL PROTECTED]> wrote:
>
> Bisa pakai trigger (event input di table_1).
>
> Atau cara manual, 2 X Insert :
>
>
>
> Misal kita mau memasukkan nama "C"
>
>
>
> 1. Insert ke table_1
>
>
>
> Insert into table_1(nama) values ('C')
>
>
>
> 2. insert ke table_3
>
> Insert into table_3(nama,data) select 'C',data from table_2
>
>
>
>
>
> _____
>
> From: [email protected] [mailto:Programmer-
[EMAIL PROTECTED]
> On Behalf Of uniquebyte
> Sent: Wednesday, May 17, 2006 3:14 PM
> To: [email protected]
> Subject: [Programmer-VB] Help Insert data
>
>
>
> bisa ga menginputkan ke dalam table, dimana setiap record pada
table
> memiliki semua anggota table lain
>
> example
> table_1
> nama
> A
>
> table_2
> Data
> 1
> 2
>
> ketika table_1 di inputkan record baru (B) maka di table_3
> table_3
> nama data
> A 1
> A 2
> B 1
> B 2
>
> mohon pencerahan dari rekan-rekan...
>
>
>
>
>
>
>
>
> Wahana Programmer Groups Links
>
>
>
>
>
>
>
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "Programmer-VB
> <http://groups.yahoo.com/group/Programmer-VB> " on the web.
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]
subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
>
> _____
>
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
