Insert multiple rows MySQL

You can insert multiple rows using a single query.

view plaincopy to clipboardprint?

1. INSERT INTO student(first_name,last_name,username) VALUES  
2. ('sameera','jaya','samjay'),  
3. ('sanath','jaya','sanjay'),  
4. ('samal','jayaweera','samaljay');  

INSERT INTO student(first_name,last_name,username) VALUES
('sameera','jaya','samjay'),
('sanath','jaya','sanjay'),
('samal','jayaweera','samaljay');