The Blog of Gordon Milcham

Update Mysql table

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.