Insert multiple rows MySQL

You can insert multiple rows using a single query.

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

No comments:

Post a Comment