Select concat alter table mysql

Mysql concatenate select results

SELECT person_id, GROUP_CONCAT(hobbies SEPARATOR ', ')
FROM peoples_hobbies
GROUP BY person_id;

Source: stackoverflow.com

Select concat alter table mysql

mysql --user=user --password=secret < alter.sql

Source: serverfault.com

Select concat alter table mysql

SELECT distinct CONCAT( 'alter table ', TABLE_SCHEMA, '.', TABLE_NAME, '  CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;' ) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'DBname';

Source: serverfault.com

Select concat alter table mysql

mysql -B -N --user=user --password=secret -e "SELECT distinct CONCAT( 'alter table ', TABLE_SCHEMA, '.', TABLE_NAME, '  CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;' ) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'DBname';" > alter.sql

Source: serverfault.com

Select concat alter table mysql

alter table DBname.DBfield CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Source: serverfault.com

Similar codes

1 vote109 views1 answer
Base64 encode sql server
SQL
0 vote98 views1 answer
How to check which sp is running in sql server
SQL
0 vote63 views1 answer
Postgresql subquery
SQL
-1 vote103 views1 answer
Mysql coalesce
SQL
1 vote107 views1 answer
Mariadb alter user host
SQL
0 vote108 views1 answer
Pl/ sql change currency
SQL
0 vote103 views1 answer
Comparing with today and yesterday record in sql query
SQL
1 vote105 views1 answer
Show indices in mysql table
SQL
0 vote111 views1 answer
Java check if something is in mysql table
SQL
0 vote131 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL