Local Drupal 7 user in database
You should not use a direct MySQL query to update anything.

In this case you can use user_save(); which it is basically, load the user object -&gt; change data -&gt; pass it to user_save(); or even better user entityAPI and entity_metadata_wrappers

The default table where drupal saves user data is users, there you can find the email and username