SQL Examples¶

Useful SQL queries for doing interesting things. Each query should be accompanied by an explanation of its purpose Viewing the latest data View the last 100 rows in the database (assuming id is an ascending (or auto-incremental) value

Database management¶

Schema management¶

Query data¶

SELECT * FROM table ORDER BY id DESC LIMIT 100

Select the last 100 rows in a table (assuming id is an auto-incremental index) and order the results in ascending order

SELECT * FROM (
  SELECT * FROM table ORDER BY id DESC LIMIT 100
) sub
ORDER BY id ASC