|
|
Update RecordUPDATE People SET firstname='Fred', address='102 7th Street' WHERE LName='SMITH'The SQL Statement above will find those in the People table: UPDATE People whose LName='Smith': WHERE LName='SMITH' and set the firstname='Fred': SET firstname='Fred', and set the address='102 7th Street': address='102 7th Street' |