Anyway to Import .txt into database on MyPHPAdmin

The title says it all i just need to import a .txt with lines of text into a MyPHPAdmin Data base

anyone ?

where are you trying to input to. like a table as a row or what
what does the txt file contain the format

if your trying to add a text file lines to a certain row in a table you would need to make sure the line in text is right.

Ok well im trying to upload a list of shells i have into rows

1 row or seperate rows

each line a seperate row

if your doing 1Column only meaning its a table called shells with a Column called link
then you could do the following

Code:

INSERT INTO Shells (link)
VALUES (http://shells)

you would have to do a Find and Replace in notepad and replace every

Code:

http

with

Code:

INSERT INTO Shells (link)
VALUES (http://shells

then you would have to just go back to every line and add a ")" at the end i just tested this by the way and it worked for me so

Anyway to Import .txt into database on MyPHPAdmin

Post a Reply

Similar Threads

Tags for this Thread