Update query in SQLite

 Execute the Update query in SQLite and change the Nitin name as a Amol.

• Database Name: MyCircle, Table Name: Friends
• |ID|Name    |Age|
  | 1 |Nitin    | 21 |
  | 2 |Kaka    | 22 |
  | 3 |Ganesh| 20 |
  | 4 |Sama    | 18 |
• syntax: update tableName set FiledName=? where FieldName=?
  or
• syntax: update tableName set assignment [, assignment]”[where expressionn];
• Query: update Friends set Name=’Amol’ where ID=1;
• Output:
  |ID|Name    |Age|
  | 1 |Amol    | 21 |
  | 2 |Kaka    | 22 |
  | 3 |Ganesh| 20 |
  | 4 |Sama    | 18 |

swamios

For More Information Please Visit