MySQL Shell CRUD With Python: Update — with examples
Using MySQL Shell in Python mode to CREATE
and SELECT
records are straight-forward processes using the insert()
and select()
methods respectively. However, we are fully aware that seldom is the case in which some of that data does not change. So how do we modify or change the data we have on-hand? In SQL, UPDATE
takes care of that. We can also apply the same UPDATE
command in MySQL Shell Python mode with the update()
method. Just as in SQL, you use the SET
clause, so too do you use it with update()
by way of the set()
method. Keep reading to see examples of these…