Skip to content

Instantly share code, notes, and snippets.

@mpstenson

mpstenson/Resize_Column_Based_On_Content.sql

Created August 31, 2016 15:52
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mpstenson/e774132238e357c83d3625201a2a79ce to your computer and use it in GitHub Desktop.
Save mpstenson/e774132238e357c83d3625201a2a79ce to your computer and use it in GitHub Desktop.
Download ZIP
Resize Column Based On Content (for mysql
Raw
Resize_Column_Based_On_Content.sql
SET @column_name = 'Custom2';
select @column_name;
SET @width_query = CONCAT('SET @max_width = (SELECT CHAR_LENGTH(' , @column_name , ') AS mlen FROM `HS_Request` ORDER BY mlen DESC LIMIT 1)+10;');
PREPARE stmt FROM @width_query;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET @query = CONCAT('ALTER TABLE HS_Request MODIFY ', @column_name, ' VARCHAR(', @max_width, ');');
PREPARE stmt FROM @query;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment