MySQL 4.1 MaxDB sudah support trigger
http://mysql.cbn.net.id/doc/refman/4.1/en/maxdb-mysql-differences.html
MaxDB supports stored procedures and functions. MySQL 5.0 and up also
supports stored procedures and functions. MaxDB supports programming of
triggers through an SQL extension. MySQL 5.0 supports triggers. MaxDB
contains a debugger for stored procedure languages, can cascade nested
triggers, and supports multiple triggers per action and row.
Nyoman Jaya Sumara wrote:
Dear all,
Sorry basic banget soal query dimysql
Saya punya 2 table mysql
tbldoyan isinya :
id title total
jjs jalan2 sore
mnm minum
mkn makan
tblresponders
nama id
ali mkn
ari mkn
budi mnm
carli jjs
kalau kita query dengan perintah select id,count(id) as jumlah from
tblresponders group by id;
hasilnya :
id jumlah
mkn 2
mnm 1
jjs 1
Pertanyaannya : gimana caranya update field total pada tbldoyan dengan field
jumlah pada hasil query tblresponders tersebut diatas??
Terima kasih sebelumnya
Regards
--
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke [EMAIL PROTECTED]
Arsip dan info milis selengkapnya di http://linux.or.id/milis
