Skip to content

Instantly share code, notes, and snippets.

@BytesCrafter

BytesCrafter/mysql-

Created September 10, 2023 14:21
Show Gist options
  • Save BytesCrafter/e413d39fced8e3272aba7d9e106eabf7 to your computer and use it in GitHub Desktop.
Save BytesCrafter/e413d39fced8e3272aba7d9e106eabf7 to your computer and use it in GitHub Desktop.
Download ZIP
MYSQL USEFULL BUT DANGEROUS COMMANDS
Raw
mysql-
# Update all email address in a users table to a specific domain name
UPDATE users
SET email = CONCAT(LEFT(email, INSTR(email, '@')), 'example.com')
@BytesCrafter
Copy link
Author

Just Starting a compilation

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment