-
Notifications
You must be signed in to change notification settings - Fork 0
Update
likly edited this page Jul 6, 2021
·
1 revision
| SQL | 方法 |
|---|---|
column = #{value} |
set(column,value) |
column = column + #{value} |
incr(column,value) |
column = column - #{value} |
decr(column,value) |
column = JSON_INSERT(column,path,val[,path1,val1]...) |
jsonInsert(column,<path,value>) |
column = JSON_REPLACE(column,path,val[,path1,val1]...) |
jsonReplace(column,<path,value>) |
column = JSON_SET(column,path,val[,path1,val1]...) |
jsonSet(column,<path,value>) |
column = JSON_REMOVE(column,path,[,path1]...) |
jsonRemove(column,paths) |