Differences
This shows you the differences between two versions of the page.
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-03-22 08:47] Joakim Forsgren |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Mysql info ====== | ====== Mysql info ====== | ||
Gick igen en SQL-fråga | Gick igen en SQL-fråga | ||
- | < | + | < |
SELECT *, | SELECT *, | ||
- | // För att ta bort, gör först en korrekt select | + | # För att ta bort, gör först en korrekt select |
SELECT * FROM `lab5_Threads` RIGHT JOIN lab5_Items USING(ThreadID) WHERE Thread IS NULL | SELECT * FROM `lab5_Threads` RIGHT JOIN lab5_Items USING(ThreadID) WHERE Thread IS NULL | ||
- | // sen ändrar man den till en delete | + | # sen ändrar man den till en delete |
DELETE lab5_Items FROM `lab5_Threads` RIGHT JOIN lab5_Items USING(ThreadID) WHERE Thread IS NULL | DELETE lab5_Items FROM `lab5_Threads` RIGHT JOIN lab5_Items USING(ThreadID) WHERE Thread IS NULL | ||
</ | </ |