Post list

Write the VIEW that lists recent posts.

Post list

You can store recent posts as a VIEW. It can be easily queried later.

CREATE VIEW recent_posts AS
SELECT id, title FROM posts ORDER BY id DESC LIMIT 10;

VIEW for the last 10 posts.

The view recent_posts is created. id, title is selected from posts. The result is sorted by id in descending order. Only the first 10 rows are returned.

Post list — details

A VIEW names a query. ORDER BY and LIMIT can be used inside a VIEW.

This way the home page gets the 10 latest posts with SELECT * FROM recent_posts instead of repeating the long query.

Exercise Post list

Create the recent_posts VIEW with the last 10 posts.

Show example solution

CREATE VIEW recent_posts AS
SELECT id, title FROM posts ORDER BY id DESC LIMIT 10;

Test yourself

Add CREATE VIEW

CREATE ____ recent_posts AS
SELECT id, title FROM posts ORDER BY id DESC LIMIT 10;

Show answer

CREATE VIEW recent_posts AS
SELECT id, title FROM posts ORDER BY id DESC LIMIT 10;

Can a VIEW have LIMIT?
- No
- Only in MySQL
- Yes
- In some cases
Show answer

Yes — LIMIT can be used inside a VIEW.
Post list: match the terms

VIEW

virtual table
ORDER BY

sort
LIMIT

limit
recent

last

Next lesson: Tag search

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies