Skip to content

Instantly share code, notes, and snippets.

@oojacoboo

oojacoboo/varchar-191-utf8mb4.sql

Last active April 27, 2018 03:08
Show Gist options
  • Save oojacoboo/26f4439e740a3cbd890e48501e3fb6e4 to your computer and use it in GitHub Desktop.
Save oojacoboo/26f4439e740a3cbd890e48501e3fb6e4 to your computer and use it in GitHub Desktop.
Download ZIP
MODIFY COLUMN to varchar(191) from varchar(255) for utfbmb4
Raw
varchar-191-utf8mb4.sql
SELECT CONCAT('ALTER TABLE `', TABLE_NAME, '` ',
GROUP_CONCAT(CONCAT('MODIFY COLUMN `', COLUMN_NAME, '` VARCHAR(191)')), ';') AS _alter
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'mydatabase'
AND COLUMN_TYPE LIKE 'VARCHAR%'
AND CHARACTER_MAXIMUM_LENGTH = 255
AND CHARACTER_SET_NAME = 'utf8mb4'
GROUP BY TABLE_SCHEMA, TABLE_NAME;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment