Advanced Search

Return to Snippet

Revision: 56471
at March 30, 2012 00:47 by jgomez
Initial Code 
UPDATE default_comments c
INNER JOIN default_profiles p ON c.user_id = p.user_id 
INNER JOIN default_users u ON c.user_id = u.id 
SET c.name = p.display_name,
c.email = u.email,
c.website = p.website
WHERE c.name = '';
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Update an empty name column in default_comments

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
UPDATE table using JOINS

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL