Advanced Search

Return to Snippet

Revision: 21520
at December 15, 2009 08:55 by czapata
Initial Code 
USE YOUR_DB_NAME;
SELECT * INTO OUTFILE 'PATH/TO/FILE.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM TABLE_NAME WHERE FILTERS_GO HERE = 1;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Dump Table Data into CSV

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL