Changes for page SQL Query

Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.ebakker
	1	+XWiki.etorken

Content

...	...	@@ -37,7 +37,7 @@
37	37	* The column names (id, created date, contents)
38	38	* The value per column (:headers[id], :headers[timestamp], :payload)
39	39
40		-When combining all of this you will end up with something like this: INSERT INTO mytable (id, created date, contents) values (:headers[id], :headers[timestamp], :payload). As you can see, we want to insert our row into the table called mytable. We want to insert three values in three separate columns (id, created date, contents). Furthermore, you should note that you can use the header values and (part of) the payload as dynamic input for those values. The notation as depicted above is paramount in making this work.
	40	+When combining all of this you will end up with something like this: {{code language="sql"}}INSERT INTO mytable (id, created date, contents) values (:headers[id], :headers[timestamp], :payload){{/code}}. As you can see, we want to insert our row into the table called mytable. We want to insert three values in three separate columns (id, created date, contents). Furthermore, you should note that you can use the header values and (part of) the payload as dynamic input for those values. The notation as depicted above is paramount in making this work.
41	41
42	42	{{info}}When the primary key value already exists in the database, you will receive an error (duplicate key violation). Just as you would expect when calling a POST twice in a row with the same unique identifier.{{/info}}
43	43
...	...	@@ -74,12 +74,8 @@
74	74
75	75	{{warning}}You should be careful when deleting records in a table! Notice the WHERE clause in the DELETE statement. The WHERE clause specifies which record(s) should be deleted. If you omit the WHERE clause, all records in the table will be deleted!{{/warning}}
76	76
77		-== 4. Assignment ==
	77	+== 4. Key takeaways ==
78	78
79		-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.
80		-
81		-== 5. Key takeaways ==
82		-
83	83	* These examples cover the basics of the SQL language
84	84	* The SQL language has its form of CRUD operations
85	85	* You can dynamically fill the values of the SQL properties with the help of SpEL expressions
...	...	@@ -89,8 +89,8 @@
89	89
90	90	* [[SQL Explained>>https://www.w3schools.com/sql/default.Asp||target="blank"]]
91	91
92		-== 7. Silent demonstration video ==
	88	+== 5. Suggested additional readings ==
93	93
94		-As this is more of theoretical microlearning, there is no video accompanying the microlearning.
	90	+If you are interested in this topic and want more information, please read the help text provided by eMagiz.
95	95
96	96	)))((({{toc/}}))){{/container}}{{/container}}