I guess that the problem is the reserved word "table" Try it: Update `table` Set column5=number1 where column 1 = number2 and column1 = number3
But the sintax is ok Regards! -----Mensaje original----- De: Kraer, Joseph [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 30 de Noviembre de 2005 10:59 a.m. Para: mysql@lists.mysql.com Asunto: Newbie Question on Update I am trying to update a couple of rows in a table by doing the following: update table set column5 = number1 where column 1 = number2 and column1 = number3 but it is not working. I tried listing the conditions separated by commas (where column 1 = number2, column1 = number3) and also didn't work. What am I doing wrong? Thanks in advance, Joseph "Tito" Kraer Business Systems Analyst Taylor, Bean & Whitaker Mortgage Corp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
