{ Berbagi, Menulis, Dan Mengajar } Ilmu…

SMS213092011_sakti_KelasA_n_C … Read entire article »

1.) CopyPbk –> DELIMITER $$ USE `sms2`$$ … Read entire article »

d1cv d2cv d3cv d4cv d5cv … Read entire article »

struktural … Read entire article »

0811 – Telkomsel Kartu Halo 0812 – Telkomsel Simpati / Kartu Halo 0813 – Telkomsel Simpati / Kartu Halo 0814 – Indosat broadband ( IM2 ) 0815 – Indosat Mentari / Matrix 0816 – Indosat Mentari / Matrix 0817 – XL 0818 – XL 0819 – XL 0828 – Sampoerna Telecom Ceria 0831 – Lippo Telecom 0838 – axis 0852 – Telkomsel As 0853 – AS 0855 – Indosat Matrix 0856 – Indosat IM3 0857 – Indosat IM3 0858 – Indosat Mentari 0859 – XL 0878 – XL 0881 – Smart Telecom 0882 – Smart Telecom 0888 – Mobile-8 Fren 0896 – 3 0897 – 3 0898 – 3 0899 – 3 0868 – PSN ( Pasifik Satelit Nusantara ) layanan Byru via satelit … Read entire article »

DOWNLOAD SOURCE –>> CobaTrigger1 — DELIMITER $$ USE `coba`$$ DROP TRIGGER `TriggerCopy`$$ CREATE TRIGGER `TriggerCopy` AFTER INSERT ON `tabel1` FOR EACH ROW BEGIN DECLARE NoTelp TEXT; INSERT INTO coba.tabel2 (id,Nama,Alamat) VALUE ( NEW.Id,NEW.Nama,NEW.Alamat); IF (SELECT LEFT(NEW.Nama,3))=081 THEN UPDATE tabel2 SET nama = REPLACE(nama,’081′,’+6281′); ELSEIF (SELECT LEFT(NEW.Nama,3))=085 THEN UPDATE tabel2 SET nama = REPLACE(nama,’085′,’+6285′); END IF; END$$ DELIMITER ; … Read entire article »

DELIMITER $$ USE `coba`$$ DROP TRIGGER `TriggerCopy`$$ CREATE /*[DEFINER = { user | CURRENT_USER }]*/ TRIGGER `TriggerCopy` AFTER INSERT ON `tabel1` FOR EACH ROW BEGIN /*UPDATE tabel2 SET nama = REPLACE(New.Nama,’081′,’+6281′);*/ INSERT INTO coba.tabel2 (id,Nama,Alamat) VALUE ( NEW.Id,NEW.Nama,NEW.Alamat); UPDATE tabel2 SET nama = REPLACE(NEW.Nama,’081′,’+6281′); END$$ DELIMITER ; … Read entire article »

DECLARE btstelepon1 INT; SELECT LOCATE(‘+’,new.SenderNumber) INTO btstelepon1; IF btstelepon1 > 0 THEN SELECT REPLACE(NEW.SenderNumber,’+62′,’0′) INTO notelp; SELECT COUNT(*) INTO jumlah FROM list_user where no_telepon = notelp; ELSE SELECT NEW.SenderNumber INTO notelp; END IF; … Read entire article »

… Read entire article »

Sometime you might facing problem to replace the string or data in mysql and you have many row inside your table.  Here is the solution you can put in to SQL command line in phpmyadmin, this solution is work for mysql too.  Before begin please back all your sql 1st, in case you make any mistake. Open phpmyadmin -> click on database -> click on table name -> click on SQL tab on top then enter the command below: UPDATE tablename SET field = replace(field, "SearchString", "ReplaceString"); please change: tablename field SearchString ReplaceString according your table name and field. you can also add where Clause ( add condition for this sql statemen ) UPDATE tablename SET field = replace(field, "SearchString", "ReplaceString") WHERE field2='SomeValue'; … Read entire article »