Skip to Content
Last modified by Danniar Firdausy on 2024/09/18 20:02
From version 18.1
edited by Erik Bakker
on 2023/01/23 10:06
Change comment: There is no comment for this version
To version 19.1
edited by Eva Torken
on 2023/09/01 14:45
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.ebakker
1 +XWiki.etorken
Content
... ... @@ -24,12 +24,8 @@
24 24  
25 25  In this example, we search for all rows within the table for which the value in the column processed is equal to false. If so, the select statement will return each row. After the query returns all rows, the update query will ensure that all these rows will be updated by changing the value in the column processed to true. This way, you ensure these records won't be retrieved the next time we execute the select statement.
26 26  
27 -== 4. Assignment ==
27 +== 4. Key takeaways ==
28 28  
29 -See if you can find any database implementation within the projects you can access. This assignment can be completed with the help of the (Academy) project that you have created/used in the previous assignment.
30 -
31 -== 5. Key takeaways ==
32 -
33 33  * eMagiz offers the option to execute an update statement right after a select statement
34 34  * In the database, this can be useful when tracking the status.
35 35  * The update statement will update all rows returned via the select statement, assuming they pass the where clause
... ... @@ -38,8 +38,7 @@
38 38  
39 39  * [[SQL Explained>>https://www.w3schools.com/sql/default.Asp||target="blank"]]
40 40  
41 -== 7. Silent demonstration video ==
37 +== 5. Suggested additional readings ==
42 42  
43 -This video demonstrates how you could have handled the assignment and gives you some context on what you have just learned.
44 -
45 -{{video attachment="intermediate-database-connectivity-update-database-after-retrieval.mp4" reference="Main.Videos.Microlearning.WebHome"/}})))((({{toc/}}))){{/container}}{{/container}}
39 +If you are interested in this topic and want more information, please read the help text provided by eMagiz.
40 +))){{/container}}{{/container}}