Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Next revision Both sides next revision
mysql_info [2009-10-15 12:36]
Joakim Forsgren 		mysql_info [2010-12-10 10:33]
Joakim Forsgren
Line 1: Line 1:
 ====== Mysql info ====== ====== Mysql info ======
-Gick igen en SQL-fråga +Gick igen några SQL-frågor 
-<code mysql>+<code>
 SELECT *,COUNT(ItemID) as Number FROM Threads LEFT JOIN Items USING(ThreadID) GROUP BY (ThreadID) SELECT *,COUNT(ItemID) as Number FROM Threads LEFT JOIN Items USING(ThreadID) GROUP BY (ThreadID)
 +
 +SELECT lab5_Threads.*,lab5_Users.*,COUNT(ItemID) as NumItems FROM `lab5_Threads` INNER JOIN `lab5_Users` USING(UserID) LEFT JOIN `lab5_Items` USING(ThreadID) GROUP BY ThreadID
 +
  
 # För att ta bort, gör först en korrekt select # För att ta bort, gör först en korrekt select