Entry

How can I update many columns of a row with a single query?

Jan 23rd, 2000 21:59
Nathan Wallace, Hans H. Anderson

Try using the UPDATE query:

    http://www.mysql.com/Manual_chapter/manual_Reference.html#UPDATE

Here is a rough example:

    update table
    set    column1 = 'column1', 
           column2 = 'column2', 
           column3 = 'column3'
    where id = 100;