Function on MySQL

Function Update
UPDATE TS_TABLE var_desc=’Blalala’, var_no=’0909′ where var_id=1;

Function Insert
INSERT INTO TS_TABLE (var_desc,var_no) value (’Blalala’,'1010′);

Funcition Delete
DELETE FROM TS_TABLE WHERE var_id=1;

Join Table
SELECT a.* FROM TABLE_A a LEFT JOIN TABLE_B b on a.var_id=b.var_id;

Function pengurangan tanggal
SELECT DATEDIFF(’2009-10-10′,now()) as HASIL;

Function UNIX_TIMESTAMP
SELECT  UNIX_TIMESTAMP(’2010-01-16 01:17:37′) as HASIL;
HASIL=1263579457

Function FROM_UNIXTIME
SELECT  FROM_UNIXTIME(’1263579457′) as HASIL;
HASIL=2010-01-16 01:17:37

Function PERIOD_DIFF and DATE_FORMAT
SELECT PERIOD_DIFF(DATE_FORMAT(’2010-01-10′,’%Y%m’),DATE_FORMAT(’2009-01-10′,’%Y%m’)) as MOON
MOON=12(bulan)