06-SQLite update, delete, 06-sqliteupdate

06-SQLite update, delete, 06-sqliteupdate
I. update syntax

Update table name set list name = new value where list name = A Value

2. Update a column of data in a row

3. Update several columns of data in a row

Iv. delete statement: Used to delete rows in a table

Syntax: delete from table name where column name = value;

5. delete data from a specified row

6. delete data from all rows but modify the table structure (the table persons still exists, but there is no data in it)

Syntax: delete from table_name or delete * from table_name;