Category: Database

replace in sql file

Created at: 2020-01-03 16:51:31 Updated at: 2020-01-03 16:51:31

in MySql

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'