Advanced Search

multiple insert with one query

/ Published in: MySQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. INSERT INTO contacts  (name,mobile)VALUES
  2. (’Manu’,'9898989891′),
  3. (’Manu2′,’9898989892′),
  4. (’Manu3′,’9898989893′),
  5. (’Manu4′,’9898989894′),
  6. (’Manu5′,’9898989891′);

URL: http://blog.webtechies.in/2010/01/18/how-to-insert-multiple-records-into-mysql-using-a-single-query/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.