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 error saying, ....
>
> --snip--
> You have an error in your SQL syntax. Check the manual that
> corresponds
> to your MySQL server version for the right syntax to use near
> '(BUSINESS_CATEGORY.BUS_CAT,BUSINESS_CATEGORY.BUS_DESC) = ('JUNK
> --snip--
>
> So, I looked up in MySQL's documentation at
> http://dev.mysql.com/doc/mysql/en/UPDATE.html, it didn't say anything
> helpful about the SQL syntax. So, what did I do wrong??
I don't think MySQL supports using parens in that regard.
Try this:
UPDATE BUSINESS_CATEGORY SET
BUSINESS_CATEGORY.BUS_CAT = 'JUNKKK',
BUSINESS_CATEGORY.BUS_DESC = 'JUNK123KK'
WHERE BUSINESS_CATEGORY.BUS_CAT_ID = '733788'
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
