Text File to mysql database

[freebsd_dude]

Hello All,

I have a text file that has mysql data in to update some tables in a mysql database.

The text.txt data looks like this:

INSERT INTO testdata VALUES ('154A', '209666-6666l');
INSERT INTO testdata VALUES ('155A', '209999-9999');

I need to add this data into a database called testinput?

Can anyone please give me a example of how i could get this done.

Thank you

[LordShryku]

Command Line:

/path/to/mysql -u [username] -p[password] [database] < test.txtp

[freebsd_dude]

Hello,

This will not work. I need to make a php and run it with CDRON.
Will be updating faster then a human can keep up with.

Freebsd

Originally posted by LordShryku
Command Line:

/path/to/mysql -u [username] -p[password] [database] < test.txtp

[/B]

😕

[LordShryku]

okay.....
[man]system[/man]
[man]exec[/man]
[man]shell_exec[/man]