Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
u5_databaser [2020-09-04 09:16] Joakim Forsgren |
u5_databaser [2022-07-18 13:20] (current) |
||
---|---|---|---|
Line 6: | Line 6: | ||
{{: | {{: | ||
<code SQL># ev Måste ni först ställa om teckentabellen | <code SQL># ev Måste ni först ställa om teckentabellen | ||
- | SET NAMES utf8</ | + | SET NAMES utf8 |
+ | |||
+ | SELECT Login, Name FROM Users INNER JOIN Observations ON Users.UserID=Observations.UserID INNER JOIN Birds ON Observations.BirdID=Birds.BirdID; | ||
+ | </ | ||
- Visa alla fåglar | - Visa alla fåglar |