Insert list of column values into MySQL from textfile

list of email addresses which I would like to insert into a MySQL table

[s9901470]

Hi

I have a list of email addresses which I would like to insert into a MySQL (version 2.6.0) table which has the fields id, username, pw, email, lastupdated.

Is there a way to adapt the following code to insert all of them at once? I basically want to ignore id, username, pw, lastupdated.

INSERT INTO mail(email) VALUES ('[e-mail]');
INSERT INTO mail(email) VALUES ('[e-mail]');

Any suggestions most welcome.

[vincevincevince]

INSERT INTO mail (email) VALUES ('[e-mail]'),('[e-mail]'),....

I believe.

[s9901470]

that works great, many thanks