Hi

I am filling my database with a couple of thousend
8 digits numbers. These numbers i have in a list in a text-file.
Also I have a dump-sql file that i fill with these numbers by copying and pasting the numbers in between the brackets after the word VALUES in the following sentence:

INSERT INTO NUMBERS (number) VALUES ();

resulting in;

INSERT INTO NUMBERS (number) VALUES (12345678);

That i repeat with all the numbers

This takes me forever.....!

Is their anybody who knows a quicker way...?
I would appriciate any suggestions deerly!

Greetings

Meeusen

Check the MySQL manual online.

-PatP

thank you !!!