A sql query that will create sql commands to convert all tables and columns from database to utf8mb4 so you can have emojis in text you sicko

converting-everything-to-utf8mb4.sql

SELECT CONCAT(
  'ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,
  ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;'
)
  FROM information_schema.TABLES
  WHERE TABLE_SCHEMA = 'databasename';