On Thu, June 30, 2005 9:05 pm, blackwater dev said: > Does anyone know if it is possible to load data into multiple > tables using one file when you use load data local infile? That is not possible. > I need to load several tables but don't want to have tons of files. You may need to change your design for this - if possible. To address "if possible" some few question need some answers first; Why do you have "tons of files / What creates all these files? Why do they need to be loaded in diffrent tables? How often does this happen? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php