Tuesday, June 9, 2015

MySQL: Multiple Inserts for a single column

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

once the bracket close it will take the values and look for another value in next bracket.

5 comments:

  1. Such a nice blog, keep sharing with us, if you want to
    buy cushion covers online india then let us know at +91–9650270867

    ReplyDelete
  2. Nice blog, keep writing like this


    Find here online price details of companies selling Mattress Cover Cotton. Get info of suppliers, manufacturers, exporters, traders of Mattress Cover Near Me for buying in India.

    ReplyDelete
  3. Nice blog, keep writing like this

    Buy Milwaukee at low prices in UK. Select from range of home improvement tools & Milwaukee UK of all brands from tools4trade.co.uk

    Milwaukee
    Milwaukee UK
    Milwaukee Power Tools
    Milwaukee Fuel
    Milwaukee UK Cordless
    Corded Power Tools
    Milwaukee power tools UK

    ReplyDelete