On Tue, Feb 24, 2009 at 8:53 PM, PJ <af.gour...@videotron.ca> wrote: > Is there a way to insert several rows into a table with one statement? > I have this: > $sql2 = "INSERT INTO authors > (first_name, last_name, ordinal) VALUES > ('$first_nameIN', '$last_nameIN', '1')"; > $result2 = mysql_query($sql2, $db); > > I want to avoid doing another insert like: > $sql3 = "INSERT INTO authors > (first_name, last_name, ordinal) VALUES > ('$first_name2IN', '$last_name2IN', '2')"; > $result2 = mysql_query($sql2, $db); >
$sql2 = "INSERT INTO authors (first_name, last_name, ordinal) VALUES ('$first_nameIN', '$last_nameIN', '1'), ('$first_name2IN', '$last_name2IN', '2')"; -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org