In this article, I'll show how to partially update JSON column using SQLAlchemy expressions in MySQL database.
Say, we have a table named TableName
with a JSON column named JsonColumn
and the values in this JSON column is in the following format;
{
"JsonAttribute": 5,
"AnotherJsonAttribute": "Hello"
}
SQL statement to update …