Hi Kate,

You use two different verbs in the explanation of your problem, update and
insert, and I am not at all sure if the problem is with your statement or
with your intent.

UPDATE is the SQL command to *change* values in existing data
INSERT is the SQL command to *add* new data to a table

So are you trying to add new data (INSERT) or change existing information
(UPDATE)?

Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


                                                                                       
                                
                      "Kate Legere"                                                    
                                
                      <[EMAIL PROTECTED]>        To:       <[EMAIL PROTECTED]>         
                              
                                               cc:                                     
                                
                      07/08/2004 01:49         Fax to:                                 
                                
                      PM                       Subject:  Update trouble                
                                
                                                                                       
                                
                                                                                       
                                




I'm trying to retrieve a certain ID row from a table and use Update to
insert it into a specific row of another table. I'm not getting any syntax
error but I'm also not getting the update to work


UPDATE linksProjects LEFT JOIN categories ON linksProjects.categoryId =
categories.categoryId SET linksProjects.categoryId = categories.categoryId
WHERE categories.catTitle = 'Vision';


Kate


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

Reply via email to