Hello all,
How would you go about uploading a flat file to MySQL database table? the file is 210mb big and is a fixed width file?
Sincerely,
Christopher
SEAS-Net
Open the file for reading, read the contents, close the file.
Open a db connection, run an INSERT query, close the connection again.
Or is there a certain structure in the text file which defines how the data in the text file should be inserted into the table(s)?
this is resolved, how do I mark this post and some others
Users should have the ability to “EDIT” their own posts.
If you chose EDIT (on the very first post) you can then ALTER the subject and append a [SOLVED] to the BEGINNING of the subject.
Please do not alter anything else within the post as it may (or may not) be useful to someone else.