replace
将新的数据替换旧的数据
replace($table, $column, $search, $replace, $where)
table [string]
表名.
columns [string/array]
The target columns of data will be replaced.
search [string]
The value being searched for.
replace [string]
The replacement value that replaces found search values.
where (optional) [array]
The WHERE clause to filter records.
replace($table, $column, $replacement, $where)
table [String]
表名.
columns [string/array]
The target columns of data will be replaced.
replacement [array]
The replacement array value that contained search value as key and replace string as value.
where (optional) [array]
The WHERE clause to filter records.
replace($table, $columns, $where)
table [string]
表名.
columns [array]
The target columns of data will be replaced.
where (optional) [array]
The WHERE clause to filter records.
Return: [number] 返回受影响的行数
$database->replace("account", "type", "user", "new_user", [
"user_id[>]" => 1000
]);
$database->replace("account", "type", [
"user" => "new_user",
"business" => "new_business"
], [
"user_id[>]" => 1000
]);
$database->replace("account", [
"type" => [
"user" => "new_user",
"business" => "new_business"
],
"group" => [
"groupA" => "groupB"
]
], [
"user_id[>]" => 1000
]);