Skip to Content
Last modified by Danniar Firdausy on 2024/09/18 20:02
From version 11.2
edited by Erik Bakker
on 2022/06/10 12:00
Change comment: Update document after refactoring.
To version 13.1
edited by Erik Bakker
on 2022/08/30 15:05
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -intermediate-database-connectivity-update-database-after-retrieval
1 +Update database after retrieval
Content
... ... @@ -1,13 +1,9 @@
1 1  {{container}}{{container layoutStyle="columns"}}(((
2 -= Update database after retrieval =
3 3  
4 4  In the previous [microlearning](intermediate-database-connectivity-sql-query.md) we discussed the fundamentals of SQL queries. In this microlearning, we will learn how you could update the record(s) in the database the moment after you have read the information from the database. This functionality can help you update a status field to ensure you won't keep reading the same record(s) repeatedly.
5 5  
6 6  Should you have any questions, please get in touch with [[academy@emagiz.com>>mailto:academy@emagiz.com]].
7 7  
8 -* Last update: September 7th, 2021
9 -* Required reading time: 4 minutes
10 -
11 11  == 1. Prerequisites ==
12 12  
13 13  * Basic knowledge of the eMagiz platform
... ... @@ -16,8 +16,6 @@
16 16  
17 17  eMagiz offers the option to execute an update statement right after a select statement. In the database, this can be useful when tracking the status.
18 18  
19 -
20 -
21 21  == 3. Update database after retrieval ==
22 22  
23 23  In the previous [microlearning](intermediate-database-connectivity-sql-query.md) we discussed the fundamentals of SQL queries. In this microlearning, we will learn how you could update the record(s) in the database the moment after you have read the information from the database. This functionality can help you update a status field to ensure you won't keep reading the same record(s) repeatedly.
... ... @@ -30,8 +30,6 @@
30 30  
31 31  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.
32 32  
33 -
34 -
35 35  == 4. Assignment ==
36 36  
37 37  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.
... ... @@ -42,8 +42,6 @@
42 42  * In the database, this can be useful when tracking the status.
43 43  * The update statement will update all rows returned via the select statement, assuming they pass the where clause
44 44  
45 -
46 -
47 47  If you are interested in this topic and want more information, please read the help text provided by eMagiz and read more information on the following link:
48 48  
49 49  * https://www.w3schools.com/sql/default.Asp
... ... @@ -52,6 +52,4 @@
52 52  
53 53  This video demonstrates how you could have handled the assignment and gives you some context on what you have just learned.
54 54  
55 -{{video attachment="intermediate-database-connectivity-update-database-after-retrieval.mp4" reference="Main.Videos.Microlearning.WebHome"/}}
56 -
57 -)))((({{toc/}}))){{/container}}{{/container}}
45 +{{video attachment="intermediate-database-connectivity-update-database-after-retrieval.mp4" reference="Main.Videos.Microlearning.WebHome"/}})))((({{toc/}}))){{/container}}{{/container}}