Nov 30, 2004 #1 minckle Programmer Mar 17, 2004 142 GB Im trying to write a small app that enables a user 2 import a file into mysql. Some of the txt files have column heading, is there in the MySQLImport fuinction to ignore this 1st line of the txt file (i.e the Headings line) Thanks
Im trying to write a small app that enables a user 2 import a file into mysql. Some of the txt files have column heading, is there in the MySQLImport fuinction to ignore this 1st line of the txt file (i.e the Headings line) Thanks
Dec 1, 2004 #2 spookie Programmer May 30, 2001 655 IN Execute mysqlimport command with --ignore-lines=n option, where n is lines you want to ignore starting from first line. -------------------------------------------------------------------------- I never set a goal because u never know whats going to happen tommorow. Upvote 0 Downvote
Execute mysqlimport command with --ignore-lines=n option, where n is lines you want to ignore starting from first line. -------------------------------------------------------------------------- I never set a goal because u never know whats going to happen tommorow.