[88mph]

is there a way to update multiple columns in one query? I can't seem to find the syntax as most tutorials are based around a single change

trying to change this insert query into an update query

PHP Code:

$query = "INSERT INTO main_inventory (

                item_type, title, brand, model, serial_no, replacement_cost, quantity, kit_content, main_location ,current_location, notes

                ) VALUES (

                    '{$item_type}','{$title}', '{$brand}','{$model}','{$serial_no}',{$replacement_cost}, {$quantity}, '{$kit_content}','{$main_location}','{$current_location}','{$notes}')"; 

[Jay6390]

it follows the syntax

UPDATE `tablename` SET
`column1` = 'value1',
`column2` = 'value2' 
WHERE 
`idcolumn` = 'something' 

You need the idcolumn or some other column to verify it's the right one that you are updating. If you are wanting to update all columns, you simply remove the everything after and including the WHERE

[88mph]

Originally Posted by Jay6390

If you are wanting to update all columns, you simply remove the everything after and including the WHERE

sorry, I don't quite follow. Are you saying there is a quicker way than listing ALL the columns in series

[Wolf1994]

As far as I know, there is no such way in case when you wish to update specific columns with specific data.

[88mph]

sorry, think I misinterpreted that. You mean to update all records, not all columns

[Nico]

Moving this to Database section...

[Wolf1994]

Sorry, I misinterpreted too. I meant records too.
If you are searching a quicker update and this is total update - i.e. update of all columns in record, you may delete all records with DELETE query and after that insert them anew with one INSERT query.

[Wolf1994]

Rereaded the original post...
You may update several columns at once with such syntax:

UPDATE `your_table`SET `column1`='value1',`column2`='value2' WHERE `id`='xxx' 

[Wolf1994]

May be this link will be helpful:
http://dev.mysql.com/doc/refman/4.1/en/update.html