Datakurser - student.oedu.se
Datakurser - student.oedu.se
  • Tools
    • User Tools
    • Log In
    • Site Tools
    • Media Manager
    • Page Tools
    • Back to top
  • Log In

  1. You are here
  2. Home
  3. Mysql info
  1. Trace
  2. Mysql info

  • Back to top
  • Share via
    • Share via...
    • Twitter
    • LinkedIn
    • Facebook
    • Pinterest
    • Telegram
    • WhatsApp
    • Yammer
    • Reddit
  • Recent Changes
  • Send via e-Mail
  • Print
  • Permalink

This is an old revision of the document!


Mysql info

Gick igen en SQL-fråga

SELECT *,COUNT(ItemID) as Number FROM Threads LEFT JOIN Items USING(ThreadID) GROUP BY (ThreadID)
 
DELETE lab5_Items FROM `lab5_Threads` RIGHT JOIN lab5_Items USING(ThreadID) WHERE Thread IS NULL