In this post we will learn how to add multiple rows to a table with one query.
Add the authors table the authors whose names are Arthur Machen and Jack London in one query.
Insert into authors (name,surname)
values ('Arthur','Machen'), ('Jack','London')
Insert into authors values
Add the students table three students whose names and classes only known.
Insert into students(name,class) values