vimwiki

Sql update data

To update data in a table, use the following syntax:

UPDATE <table name> 
SET <column name> = <value> 
WHERE <condition>;

For example, to update the “age” of a student named “Alice”:

UPDATE students 
SET age = 21 
WHERE name = 'Alice';