官术网_书友最值得收藏!

Retrieving data

Now that we have inserted data into the students, courses, and students_courses tables, let us look at the different mechanisms of retrieving data, we will be using the SELECT command to retrieve the data. The SELECT statement would expect two things as a minimum, the first would be what to retrieve and the second would be where to retrieve it. The simplest SELECT command would be to retrieve all the student records from the students table:

Retrieving data

In this query, we are using * to retrieve the data for all the columns from the students table, this is not a preferred method of retrieving data. The preferred method for data retrieval is by mentioning the individual columns separated by a comma (,) after the SELECT clause:

Retrieving data

In this query, we are selecting the student_id, first_name, and last_name columns from the students table. As we are not filtering the data yet, SELECT statements would return every student record that is in the students table. We can use the LIMIT clause to retrieve a certain number of records:

Retrieving data

In this query, we are retrieving the data from the students table and we are retrieving the student_id, first_name, and last_name columns; however, rather than retrieving all the rows, we are only retrieving a single row. To retrieve the next row, we could still use the limit, but we would use LIMIT clause accompanied by the OFFSET clause. The OFFSET clause determines the starting point as to where the records should start from, while the LIMIT clause determines the number of records that would be retrieved.

主站蜘蛛池模板: 新丰县| 罗定市| 石林| 永新县| 始兴县| 明水县| 介休市| 财经| 同仁县| 丁青县| 蓬溪县| 江津市| 分宜县| 婺源县| 娄烦县| 咸丰县| 阿鲁科尔沁旗| 沅江市| 安远县| 治多县| 游戏| 恩施市| 红原县| 山阳县| 建德市| 和政县| 苍山县| 望都县| 文山县| 曲沃县| 长沙市| 遂溪县| 宣恩县| 泸定县| 达日县| 沂南县| 巢湖市| 普宁市| 广安市| 民乐县| 板桥市|