Nov 30, 2004 #1 minckle Programmer Joined Mar 17, 2004 Messages 142 Location 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 Joined May 30, 2001 Messages 655 Location 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.