SQL nested queries

Drupal SQL :

Useful query if you need to find all users that don't have a role using nested queries =

select * FROM users
WHERE NOT EXISTS
  ( select *
     from users_roles
     where users.uid = users_roles.uid) AND users.uid <> 0;

ALSO the delete works :

DELETE FROM users
WHERE NOT EXISTS
  ( select *
     from users_roles
     where users.uid = users_roles.uid) AND users.uid <> 0;



»
  • share

Post new comment

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>. The supported tag styles are: <foo>, [foo].

More information about formatting options

Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
Bg