{ Berbagi, Menulis, Dan Mengajar } Ilmu…

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 »

MySQL provides wide selection of functions which may be called during a SQL statement to make changes to text values. The following table lists the most frequently used functions in this category. Some example of how to use these functions are included after the table. For extensive details on how to use each of these functions refer to the MySQL Reference Guide: <SCRIPT LANGUAGE=’JavaScript’ TYPE=’text/javascript’ > document.write(‘<a href=”http://a.tribalfusion.com/h.click/apmRoPoTjIXF7gUtrUm6fJnsfopWMH5Erf3WIr3AnZapbUZc0GvPXsr40cBxpTfR5bJPVFnGVAjWQErQSsrpQt7s1d7xT6jy4sMUXFBDU6im5mQ8R6fH3tnsXW3AmtAN4PYP3sngTsUaWGjlR6QyUHJPWoTCr9FZdSCuHN9aUMSvkxRiLs63UVnyZdmSAn0mFrWo7QuTeIZdEuidj/http://clk.atdmt.com/INM/go/347254610/direct/01/955368118/” target=”_blank”><img src=”http://view.atdmt.com/INM/view/347254610/direct/01/955368118/” /></a>’);</SCRIPT> <NOSCRIPT> <A HREF=’http://a.tribalfusion.com/h.click/apmRoPoTjIXF7gUtrUm6fJnsfopWMH5Erf3WIr3AnZapbUZc0GvPXsr40cBxpTfR5bJPVFnGVAjWQErQSsrpQt7s1d7xT6jy4sMUXFBDU6im5mQ8R6fH3tnsXW3AmtAN4PYP3sngTsUaWGjlR6QyUHJPWoTCr9FZdSCuHN9aUMSvkxRiLs63UVnyZdmSAn0mFrWo7QuTeIZdEuidj/http://clk.atdmt.com/INM/go/347254610/direct/01/955368118/’ TARGET=’_blank’ > <IMG SRC=’http://view.atdmt.com/INM/view/347254610/direct/01/955368118/’ BORDER=’0′ > </A> </NOSCRIPT> Name Description ASCII() Returns numeric value of left-most character BIN() Returns a string representation of the argument BIT_LENGTH() Returns length of argument in bits CHAR_LENGTH() Returns number of characters in argument CHAR() Returns the character for each integer passed CHARACTER_LENGTH() The same as CHAR_LENGTH() CONCAT_WS() Returns concatenate with separator CONCAT() Returns concatenated string CONV() Converts numbers between … Read entire article »

Workshop Requirements You should have completed Parts One, Two, Three, Four and Five of this series. You should also have access to the MySQL command line client software. You should also have full permissions on a database. Introduction Thus far when retrieving stored data we have simply displayed the results of any query. MySQL can do more that this and has many built in functions that can transform data to meet our requirements. These include: Date Functions - used to manipulate the display format of a date as well as calculate time. String Functions – can manipulate a text string Numeric Functions - can manipulate figures Summarising Functions - output meta results from a query There are also Control Functions that can be used to give conditionality to queries. Date Functions Before looking at … Read entire article »

MySQL database has a handy and simple string function REPLACE() that allows table data with the matching string (from_string) to be replaced by new string (to_string). This is useful if there is need to search and replace a text string which affects many records or rows, such as change of company name, postcode, URL or spelling mistake. The syntax of REPLACE is REPLACE(text_string, from_string, to_string) MySQL reference describes REPLACE as function that returns the string text_string with all occurrences of the string from_string replaced by the string to_string, where matching is case-sensitive when searching for from_string. text_string can be retrieved from the a field in the database table too. Most SQL command can be REPLACE() function, especially SELECT and UPDATE manipulation statement. For example: update … Read entire article »