Search snippets
Browse Code Answers
FAQ
Usage docs
Log In
Sign Up
Home
SQL
update table remove a key from json object mysql
Sam
Programming language:
SQL
2021-03-22 16:19:06
0
Q:
update table remove a key from json object mysql
NZMAI
Code:
SQL
2021-07-21 17:27:13
UPDATE emp SET emp.col = JSON_REMOVE(emp.col, '$.field1');
0
Tags
object
key
table
remove
mysql
json
tab
date
Related
mysql drop key
how to remove foreign key constraint in sql
delete foreign key sql
drop unique key from column mysql
how to remove unique key constraint in mysql
mysql get json value by key
postgresql update json field key value
mysql remove foreign key constraint
how to update json key name while keeping the values in mysql
how to remove unique key in mysql
New to Communities?
Join the community