MySQL Update Multiple Columns Query

While the book only includes a single example on page 117 for the MySQL UPDATE query, it should have also included an example of a multiple column UPDATE. Here is an example:

UPDATE table SET column1=’newvalue’,column2=’nextvalue’ WHERE column3=’value’

Similar Posts:

• Search Speed: Isset vs In_array vs MySQL Query
• mysql_result() correction
• MySQL Find Fields in Table not Found in First Table
• mysql_real_escape_string() vs addslashes()
• Amazon Kindle Reduced Price to $299