I am not getting which SQL statement should be used to insert multiple data at a same time without writing
insert into... again and again.
suppose whenever i want to insert data into 'customer' table then i may write statement as
insert into customer(c_id,c_name,c_city,c-street) values('C101','Hayes','Downtown','Main')
But it will create only one row and for next row i have to repeate the same things.
Is there any query which will directly ask me to enter many rows?