SQL Update

Code Markup
UPDATE Customers
SET ContactName='Alfred Schmidt', City='Hamburg'
WHERE CustomerName='Alfreds Futterkiste'; 

Be Smarter.
Mind Maps