Advanced Search

Return to Snippet

Revision: 59232
at August 26, 2012 06:00 by kirkfortune
Initial Code 
LOAD DATA LOCAL INFILE '/file.csv' INTO TABLE `table_name` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'
(field1,field2,etc)
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
ensure the url to the csv file is in the root of your file system (eg: C:/mycsvfile.csv)

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Insert into mysql from csv file

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL