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 | ||
birds_databaser [2014-04-14 20:58] Joakim Forsgren |
birds_databaser [2015-08-28 10:53] Joakim Forsgren |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== SELECT frågor | + | ====== SELECT frågor |
Nu skall nu använda min databas **jf_select**. (login: jf_select, passwd: jf_select) | Nu skall nu använda min databas **jf_select**. (login: jf_select, passwd: jf_select) | ||
När det står tips så är det något nytt, det räcker inte enbart med det som står som tips. Ni kommer behöva läsa i manualen för att lyckas skulle jag tro :-)\\ | När det står tips så är det något nytt, det räcker inte enbart med det som står som tips. Ni kommer behöva läsa i manualen för att lyckas skulle jag tro :-)\\ | ||
Line 108: | Line 108: | ||
SELECT * FROM Birds; | SELECT * FROM Birds; | ||
- | 2. | + | 9. |
SELECT * FROM Observations | SELECT * FROM Observations | ||
WHERE UserID=3; | WHERE UserID=3; | ||
- | 3. | + | 10. |
SELECT * FROM Users INNER JOIN Observations USING(UserID) | SELECT * FROM Users INNER JOIN Observations USING(UserID) | ||
WHERE Login=' | WHERE Login=' | ||
- | 4. | + | 11. |
SELECT Name, | SELECT Name, | ||
FROM Birds INNER JOIN Observations USING(BirdID) | FROM Birds INNER JOIN Observations USING(BirdID) | ||
Line 123: | Line 123: | ||
ORDER BY Antal DESC; | ORDER BY Antal DESC; | ||
- | SELECT Name, | + | 12. |
+ | SELECT Name, | ||
- | 5. | + | 14. |
SELECT CONCAT(FirstName,' | SELECT CONCAT(FirstName,' | ||
FROM Users INNER JOIN Observations USING(UserID) | FROM Users INNER JOIN Observations USING(UserID) | ||
Line 131: | Line 132: | ||
ORDER BY Antal DESC; | ORDER BY Antal DESC; | ||
- | 6. | + | 15. |
SELECT Name, | SELECT Name, | ||
FROM Birds INNER JOIN Observations USING(BirdID) | FROM Birds INNER JOIN Observations USING(BirdID) | ||
Line 137: | Line 138: | ||
GROUP BY BirdID ORDER BY Antal DESC; | GROUP BY BirdID ORDER BY Antal DESC; | ||
- | 7. | + | 16. |
SELECT CONCAT(FirstName,' | SELECT CONCAT(FirstName,' | ||
FROM Users INNER JOIN Observations USING(UserID) | FROM Users INNER JOIN Observations USING(UserID) |