MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `games`(  
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(255) NOT NULL,
  `genre` ENUM('action','adventure','shooter','rasing') NOT NULL,
   KEY(`id`)
) CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO games (title, genre) VALUES
('Title = action', 'action'),
('Title = adventure', 'adventure'),
('Title = shooter', 'shooter'),
('Title = rasing', 'rasing');
SELECT * FROM games;

Records: 4  Duplicates: 0  Warnings: 0




id
title
genre


1
Title = action
action

2
Title = adventure
adventure

3
Title = shooter
shooter

4
Title = rasing
rasing


/*
ALTER TABLE games 
  MODIFY COLUMN `genre` ENUM('action','adventure','shooter','rasing','racing') NOT NULL;
UPDATE games SET genre = 'racing' WHERE genre = 'rasing';
ALTER TABLE games 
  MODIFY COLUMN `genre` ENUM('action','adventure','shooter','racing') NOT NULL;
SELECT * FROM games;
*/
/*
ALTER TABLE games 
  MODIFY COLUMN `genre` VARCHAR(10) NOT NULL;
UPDATE games SET genre = 'racing' WHERE genre = 'rasing';
ALTER TABLE games 
  MODIFY COLUMN `genre` ENUM('action','adventure','shooter','racing') NOT NULL;
SELECT * FROM games;
*/
ALTER TABLE `games` 
  MODIFY COLUMN `genre` TINYINT NOT NULL;
ALTER TABLE `games` 
  MODIFY COLUMN `genre` ENUM('action','adventure','shooter','racing') NOT NULL;
SELECT * FROM games;

Records: 4  Duplicates: 0  Warnings: 0



Records: 4  Duplicates: 0  Warnings: 0




id
title
genre


1
Title = action
action

2
Title = adventure
adventure

3
Title = shooter
shooter

4
Title = rasing
racing

id	title	genre
1	Title = action	action
2	Title = adventure	adventure
3	Title = shooter	shooter
4	Title = rasing	rasing