Advanced Search

Return to Snippet

Revision: 57006
at May 2, 2012 22:41 by imbraz
Initial Code 
CREATE TABLE schema.NEWTable LIKE schema.OLDTable;
INSERT schema.NEWTable SELECT * FROM schema.OLDTable;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Create a new table from the details of another table then insert the table contents

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Copy an SQL Table

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, copy

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL