...

View Full Version : How to insert a lot of values(in wrong form) in database



Krentenbol
12-15-2011, 01:44 PM
Has anyone an Idea how I could convert or something this format so I could insert it into a database:

Id, Firstname, Lastname
1, John, Smith
2, Charles, Williams

Etc.
I've no idea how I should do this.

guelphdad
12-15-2011, 02:37 PM
look up LOAD DATA INFILE in the manual.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum