Update Table dynamically in mySQL

So, if you want to update table in mySQL dynamically here is the code.

SET @table = 'kas_permohonan_m';
SET @update = 'status=''TEST''';
SET @where = 'nomor = ''KP010001''';
SET @SQL = CONCAT('UPDATE ',@table,
                  ' SET '  ,@update,
                  ' WHERE ',@where);
PREPARE stmt FROM @SQL;
EXECUTE stmt;

Perbedaan syntax SQL Server dan mySQL

Menggabungkan String


SQL Server : 
SELECT Nama = 'Taufik' + 'Lukman'
Nama = 'TaufikLukman'

mySQL:
SELECT CONCAT('Taufik','Lukman') AS Nama
Nama ='Taufik Lukman'

Mendapatkan Tanggal & Jam
SQL Server : 
SELECT GETDATE() as Tanggal
Tanggal = 2012-03-06 11:46:06

mySQL:
SELECT SYSDATE() as Tanggal
Tanggal = 2012-03-06 11:46:06

Membuat Function di mySQL

CREATE FUNCTION `fn_mst_rekening_nama`(`p_id` varchar(2))
RETURNS VARCHAR(20)
LANGUAGE SQL
DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''

BEGIN
DECLARE nama_rekening VARCHAR(20);
SELECT nama INTO nama_rekening
FROM mst_rekening
WHERE ID = p_id;
RETURN nama_rekening;
END;