Advanced Search

Return to Snippet

Revision: 10105
at December 8, 2008 11:32 by janetmck
Initial Code 
CREATE TEMP TABLE tempcourse as SELECT * FROM bookings WHERE presentation=xxxxxx
UPDATE tempcourse SET presentation=yyyyyy
INSERT INTO bookings SELECT * FROM tempcourse
DROP TABLE tempcourse;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Copy selection from one table to another with changes

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL