Updating Data
This lesson discusses how to use the Update clause in MySQL.
We'll cover the following...
We'll cover the following...
Updating Data
We can use the UPDATE statement to change the value of a column for a row or multiple rows.
Example Syntax
UPDATE table
SET col1 = val1, col2 = val2, … coln = valn
WHERE <condition>
ORDER BY col5
LIMIT 5;
Connect to the terminal below by clicking in the widget. Once connected, ...