Bishop's Pond

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
dbquery:test2 [2025/08/27 09:18] Richard Whitedbquery:test2 [2025/08/27 12:03] (current) Richard White
Line 1: Line 1:
- ====== Test2 query ======+ ====== Test2 table query ======
  
 <code sql> <code sql>
-SELECT common_name AS "Common name", scientific_name AS "Scientific name", date, location, note FROM species;+SELECT common_name AS "Common name", scientific_name AS "Scientific name", date, location, note, id FROM species ORDER BY scientific_name;
 </code> </code>
  
dbquery/test2.1756286333.txt.gz · Last modified: by Richard White