The Queries in this page solved at the library database. It is a sample database generated by randomly records. You can download it from the link. You will see more than 500 examples in the future. You can filter from the search panel above by selecting sql statements. I hope you will like it

# SQL Insert Examples

##### 1-) Add the writer named Zane Grey to the authors table

Solution 1)

Insert into authors
values('x','y')

Solution 2)

Insert into authors(name,surname)
values('x','y')

ETİKETLER

-
##### 2-) Add the student named Ace Collins to the students table

Solution 1)

Insert into students
values ('x','y',null,null,null,null)

Solution 2)

Insert into students(name,surname)
values ('x','y')

ETİKETLER

-
##### 3-) Add the writers named Ernest Dowson and Mother Goose to the authors table

Solution 1)

Insert into authors(name,surname)
values('Ernest','Dowson'),
('Mother','Goose')

Solution 2)

Insert into authors
values ('Ernest','Dowson'),
('Mother','Goose')

ETİKETLER

-
Library Database