faqts : Computers : Programming : Languages : PHP : Database Backed Sites : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

154 of 191 people (81%) answered Yes
Recently 6 of 10 people (60%) answered Yes

Entry

Insert multiple rows into MySQL

Sep 4th, 2000 19:47
Craig Fratrik, sam harwin, http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#INSERT


The code is as follows:
     INSERT INTO <table> (<col1>, <col2>...) VALUES (<val1 for col1>, 
val1 for col2>...), (<val2 for col1>,<val2 for col2>...)...;