Vallabh Kansagara <vrkansagara@gmail.com>

Vallabh Kansagara ( VRKANSAGARA )

A day by Software Engineering ,Open source contributor at @GitHub with various projects.

Packagist Mirror India

Latest updates

How to sign you git commit

# Generate a new pgp key: (better to use gpg2 instead of gpg in all below commands)
gpg --gen-key
# maybe you need some random work in your OS to generate a key. so run this command: `find ./* /home/username -type d | xargs grep some_random_string > /dev/null`

# check current keys:
gpg --list-secret-keys --keyid-format LONG

# See your gpg public key:
gpg --armor --export YOUR_KEY_ID
# YOUR_KEY_ID is the hash in front of `sec` in previous command. (for example sec 4096R/234FAA343232333 => key id is: 234FAA343232333)

# Set a gpg key for git:
git config --global user.signingkey your_key_id

# ...

replace in sql file

Replace work in large sql file using bellow command.

sed -i '' 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g'

or

sed -i 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g'