alter table

collate valtoztatas adott db osszes tablajanak osszes oszlopanak.

for i in `echo $(mysql -u dbadmin -pdbadminjelszo -Bse 'show tables from adatbazis;')` ; do mysql -u dbadmin -pdbadminjelszo -Bse "SHOW FULL FIELDS from adatbazisneve.$i;" | grep 'swedish' | awk -vtablanev=$i '{print "use adatbazisneve; ALTER TABLE "tablanev" CONVERT `"$1"` `"$1"` "$2" CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;"}' | mysql -u dbadmin -pdbadminjelszo; done

uez a tablakra:

for i in `echo $(mysql -u dbadmin -pdbadminjelszo -Bse 'show tables from adatbazis;')` ; do mysql -udbadmin -pdbadminjelszo -Bse "ALTER TABLE adatbazis.$i DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;"; done