Advanced Search

Return to Snippet

Revision: 50631
at August 29, 2011 22:34 by preasha
Initial Code 
UPDATE revisions AS target
INNER JOIN (select revision_id AS rev_id, id AS f_id from tmp2) as source
ON target.id = source.rev_id
SET target.file_de_id = source.f_id;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
The inner join could be nested too

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Update table with values selected in a subquery

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, table, update

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL