SQL - The INSERT Statement
About the Lecture
The lecture SQL - The INSERT Statement by Martin Holzke is from the course SQL Database for Beginners. It contains the following chapters:
- Introduction - The INSERT Statement
- How to do the Insert
- Explicit Insert Version
- Multiple Inserts in one Insert Statement
Author of lecture SQL - The INSERT Statement
Martin Holzke
Customer reviews
5,0 of 5 stars
| 5 Stars |
|
5 |
| 4 Stars |
|
0 |
| 3 Stars |
|
0 |
| 2 Stars |
|
0 |
| 1 Star |
|
0 |
Excerpts from the accompanying material
... queries as shown in the lecture to verify that you will affect the desired and only the desired records. Otherwise you may damage the content of your database and be unable to execute the following exercises. Also make sure to verify the table content after execution. 2) Write a query adding a ...
... query promoting Paul Miller to “External Project Manager”, the assignment added by the previous query. Answer: First determine the keys of the roles to promote from and to: select * from role. Now update the record inserted with the previous query: Update projectperson set rid = 6 where prid = 4 and pid = 2 and rid = 7 ...
