Advanced Search

Return to Snippet

Revision: 39212
at January 14, 2011 22:37 by sjacunningham
Initial Code 
create table NEW_TABLE_NAME select * from EXISTING_TABLE where SOME_VAILD_WHERE_CLAUSE
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
This is ideal for testing queries etc.  Run this to copy a selection of data into a new table with the same scructure.  Then you can run test queries etc on it.  Once you are happy then run the queries on the live data table...enjoy

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Create new table from a selection from another existing table (including copying data structure)

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
data

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL