AudioFerret/v1/sql/qryTrack Playing

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< AudioFerret‎ | v1‎ | sql
Revision as of 02:38, 10 January 2012 by Woozle (talk | contribs) (extracted from main page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Purpose: in theory, reduces bandwidth usage by having the server send only the currently playing track rather than sending the whole list and having the client hunt for the one that's playing. In practice, we often want to know the last N tracks... so maybe we need a query for that instead.
  • Uses: Tracks_Played

SQL

<mysql>CREATE OR REPLACE VIEW qryTrack_Playing AS 

 SELECT * from Tracks_Played ORDER BY ID DESC LIMIT 1;</mysql>
Retrieved from "https://htyp.org/mw/index.php?title=AudioFerret/v1/sql/qryTrack_Playing&oldid=16646"