Changes for page SQL Query

Summary

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

Details

Page properties

Content

...	...	@@ -47,11 +47,11 @@
47	47
48	48	With a select statement, you read one or more records from the database. Within a select statement, you define the following:
49	49
50		-* The columns you want to be returned (\* in case of all columns)
	50	+* The columns you want to be returned (~* in case of all columns)
51	51	* The table from which to read
52	52	* Optional: A condition (WHERE x=x)
53	53
54		-When combining all of this, you will end up, in the simplest form, with something like this: SELECT \* from mytable. Expanding on that, we could define that we only want to retrieve the id and contents column. To do so, we slightly alter our SQL query to this: SELECT id,contents from mytable. Building on that further, we could add a condition to the statement, a so-called where clause. With the help of that clause, we can even further narrow down our result set. An example of that would be SELECT id,contents from mytable WHERE id = :headers[id].
	54	+When combining all of this, you will end up, in the simplest form, with something like this: SELECT ~* from mytable. Expanding on that, we could define that we only want to retrieve the id and contents column. To do so, we slightly alter our SQL query to this: SELECT id,contents from mytable. Building on that further, we could add a condition to the statement, a so-called where clause. With the help of that clause, we can even further narrow down our result set. An example of that would be SELECT id,contents from mytable WHERE id = :headers[id].
55	55
56	56	{{info}}A SELECT statement never alters the state of the row in the database itself.{{/info}}
57	57