The Blog of Gordon Milcham

This will update data in a MySQL table whether is empty or not.

UPDATE artists SET city = ‘Los Angeles’  WHERE city=’Sydney’

In this case Sydney will be replaced by Los Angeles.



Subscribe to get the latest posts sent to your email.




Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.