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
u5_databaser [2020-09-04 09:16]
Joakim Forsgren
u5_databaser [2022-07-18 13:20] (current)
Line 6: Line 6:
 {{:selectuppgifter_html_m3687461c.png|}} {{:selectuppgifter_html_m3687461c.png|}}
 <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</code>+SET NAMES utf8 
 + 
 +SELECT Login, Name FROM Users INNER JOIN Observations ON Users.UserID=Observations.UserID INNER JOIN Birds ON Observations.BirdID=Birds.BirdID; 
 +</code>
  
   - Visa alla fåglar   - Visa alla fåglar