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 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]

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'



   
 
  Scott Fletcher 
 
  [EMAIL PROTECTED]To:   [EMAIL PROTECTED]  
  
  com cc: 
 
   Fax to: 
 
  06/16/2004 04:08 Subject:  MySQL -- SQL syntax 
error. 
  PM   
 
   
 
   
 




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??

Thanks,
 Scott F.



--
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]