1) Basic Query
SELECT * FROM table
2) Limit the Display of a Query
This displays only 10 rows of data
SELECT * FROM table LIMIT 10
This displays only 10 rows of data but starting from 0
SELECT * FROM table LIMIT 0,10
3) Order the Display of a Query
Alphanumerically order rows by a field using either Ascending (ASC) or Descending
(DESC).
SELECT * FROM table ORDER BY field_id ASC
NewSourceMedia is providing links to these listings as
a courtesy, and makes no representations regarding the content or
any information related thereto. Any questions, complaints or claims
regarding the downloaded content or details must be directed to the appropriate
publisher. We do not encourage or condone the use of any
software in violation of applicable laws.
CATEGORIES
