UPDATE:
*Update all rows meeting a condition
Update all rows meeting a condition
suggest changeUPDATE person SET state = 'NY' WHERE city = 'New York';
Found a mistake? Have a question or improvement idea?
Let me know.
UPDATE person SET state = 'NY' WHERE city = 'New York';