DB Tips

From Kolmisoft Wiki
Revision as of 09:26, 12 November 2009 by Admin (talk | contribs) (New page: = How to find user by device ID = Change X to know device ID: select users.* from users join devices on (users.id = devices.user_id) where devices.id = X;)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

How to find user by device ID

Change X to know device ID:

select users.* from users join devices on (users.id = devices.user_id) where devices.id = X;