Advanced Search

Return to Snippet

Revision: 28035
at June 30, 2010 00:37 by breign
Initial Code 
### LOAD DATA FROM FILE
### This is working in MySQL Query Browser on Windows
LOAD DATA LOCAL INFILE "C:\\Documents and Settings\\benjo\\Desktop\\keys.csv"
INTO TABLE keys_allowed
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\n'
(key, user);
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
mysql query to populate table from data in file

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, file, csv

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL