Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Is it possible to update 3 columns with one query

Is it possible to update 3 columns with one query

Thread began 1/06/2023 7:03 am by jo271221 | Last modified 1/06/2023 10:57 am by jo271221 | 185 views | 1 replies

1/06/2023 10:57 amRay BorduinWebAssist

You just need commas in between like...
UPDATE tbl_horses SET
sire = 'Got Caught Speedin',
dam = 'Marthas Bullet',
damssire = 'Maximus'
WHERE horse_name = 'Marthasspeedinbullet'

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.