PDA

Pogčedajte punu verziju : Command-line konvertovanje MySQL baze u UTF-8


Dušan Dželebdžić
12. 12. 2011., 20:50
mysql --database=dbname -B -N -e "SHOW TABLES" \
| awk '{print "ALTER TABLE", $1, "CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"}' \
| mysql --database=dbname &

DavidWinterbottom (http://stackoverflow.com/users/25517/davidwinterbottom) sa Stackoverflowa