the fastest way to insert multiple rows in mysql with a fixed value for a column

erinandpez

New Member
I'm looking for the fastest way to insert multiple rows in a MySql table with two columns. One column has a constant value (1 for example) while the other always changes.I am using php and i have a large string with email addresses (thousands), i want to put it in a table with the columns: email_cat_id and email_address. The email_cat_id is constant while the email_address change for every email.
 
Back
Top