sql中插入数据时,若已有该条数据处理方式
原有的数据插入格式:
insert into table_name values('key','value')
新的实现方法如下:
实现一:
replace into table_name values('key','value')
实现二:
insert into table_name values('key','value') on duplicate key update field_one=variable_value[,field_two=variable_value...]
案例代码:
function userSessionWrite($sess_id, $sess_content) {
// 完成写
$sql = "REPLACE INTO `session` VALUES ('$sess_id', '$sess_content', unix_timestamp())";
// $sql = "INSERT INTO `session` VALUES ('$sess_id', '$sess_content') ON DUPLICATE KEY UPDATE session_content='$sess_content', last_time=unix_timestamp()"
return mysql_query($sql);
}