SQL - The UPDATE- and DELETE Statement
About the Lecture
The lecture SQL - The UPDATE- and DELETE Statement by Martin Holzke is from the course SQL Database for Beginners. It contains the following chapters:
- Introduction - The Update Statement
- How to do the update
- How to change more than one record
- The Delete Statement
- The to delete more than one record
Author of lecture SQL - The UPDATE- and DELETE 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
... be inserted into table projectperson: select * from person where firstname=’Paul’ and lastname=’Miller’ select * from role where label=’External Developer’ select * from project where label=’twitter’ Now insert new assignment: insert into projectperson (prid, pid, rid) values (4, 2, 7) Pre- and post-test with: select * from projectperson 6) Write a ...
... Post-test with: select * from role 9) Write a query removing the project “twitter”. Answer: delete from project where label=’twitter’ Pre-test with: select * from project where label=’twitter’ Post-test with: select * from project yRegister as a Learntoprogram.tv ...
