紀錄些小事情

DELETE FROM `mat_log` WHERE `log_remark` = 'note';


SELECT *
FROM `mat_log`
WHERE 1 AND `log_id` > '20060714013' LIMIT 0 , 30

20060714014
20060714015
20060714016
20060714017
20060714018

UPDATE `mat_log` SET `mat_age` = '9999'
WHERE `log_id` = '20060714015' LIMIT 1 ;

$sql = 'UPDATE `mat_log` SET `mat_age` = \'9999\'
WHERE `log_id` = \'20060714015\' LIMIT 1 ';

UPDATE `mat_log` SET `mat_age` = '9999'
WHERE `log_id` = '20060714016' LIMIT 1 ;

UPDATE persondata SET age=age+1


UPDATE `mat_log` SET `mat_many` = `mat_many` + '99' , `mat_many` = `mat_many` + '99';