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');

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete