Re: MySQL - UPDATE & INSERT

The UPDATE syntax in the manual: http://www.mysql.com/doc/U/P/UPDATE.html UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1, [col_name2=expr2, ...] [WHERE where_definition] [LIMIT #] Yes, it is different than the INSERT syntax. PS> ...but only there are like 150 different variables and it will take me PS> forever to write a query like.... Therein lies your problem - quite likely you need to normalize! - Julie --> Julie Meloni --> julie@thickbook.com --> www.thickbook.com Find "Sams Teach Yourself MySQL in 24 Hours" at http://www.amazon.com/exec/obidos/ASIN/0672323494/thickbookcom-20