Raspberry Pi 3 Cookbook for Python Programmers - Third Edition

The UPDATE command

The UPDATE command will allow us to change (SET) the values of data in each of the specified columns. We can also combine this with the WHERE command to limit the records the change is applied to:

UPDATE table_name 
    SET column_name2=49name2=49,column_name3=30name3=30.111997 
    WHERE column_name1name1= 'Douglas Adams'Adams';