Code:
DELETE FROM preferences WHERE id NOT IN ( "1" , "5b1e83a072fdaba62" , "59d4f93af0f702adc" , "59e7a24a6a3896ce9" ) ;
DELETE FROM preferences WHERE id NOT IN ( "1" , "5b1e83a072fdaba62" , "59d4f93af0f702adc" , "59e7a24a6a3896ce9" ) ;
SELECT `user`.user_name, preferences.id, preferences.data FROM `user` Inner Join preferences ON `user`.id = preferences.id
SELECT `user`.user_name, preferences.id, preferences.data FROM `user` Inner Join preferences ON `user`.id = preferences.id
Leave a comment: