Re: MySQL -- SQL syntax error.....

2004-06-16 Thread SGreen
Try this: UPDATE BUSINESS_CATEGORY SET BUSINESS_CATEGORY.BUS_CAT = 'JUNKKK' ,BUSINESS_CATEGORY.BUS_DESC = 'JUNK123KK' WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '733788'

RE: MySQL -- SQL syntax error.....

2004-06-16 Thread Mike Johnson
From: Scott Fletcher [mailto:[EMAIL PROTECTED] > When I use this SQL statement, ... > > --snip-- > UPDATE BUSINESS_CATEGORY SET > (BUSINESS_CATEGORY.BUS_CAT,BUSINESS_CATEGORY.BUS_DESC) = > ('JUNKKK','JUNK123KK') WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '733788' > --snip-- > > I get the SQL syntax e