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

Insert -
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

Insert -
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

Insert -
Library Database
Database