Difference between revisions of "DB Tips"

From Kolmisoft Wiki
Jump to navigationJump to search
(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;)
 
(No difference)

Latest revision as of 09:26, 12 November 2009

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;