While working with database i came to one situation where at first i have unique key for email in users table but later there come a situation we now i have to remove unique key.
So this is how i made it work.
SHOW INDEX FROM users;
Then based on the result returned you have can remove the key.
ALTER TABLE users DROP INDEX users_email_unique;
Before
After
For further actions, you may consider blocking this person and/or reporting abuse
Adela -
Code Boxx -
Lev Nahar -
Ezzdin Atef -
Once suspended, bpss2010 will not be able to comment or publish posts until their suspension is removed.
Once unsuspended, bpss2010 will be able to comment and publish posts again.
Once unpublished, all posts by bpss2010 will become hidden and only accessible to themselves.
If bpss2010 is not suspended, they can still re-publish their posts from their dashboard.
Once unpublished, this post will become invisible to the public and only accessible to Bhanu Pratap Singh.
They can still re-publish the post if they are not suspended.
Thanks for keeping DEV Community safe. Here is what you can do to flag bpss2010:
Unflagging bpss2010 will restore default visibility to their posts.
Top comments (0)