mariadb - Grouping values for a column in mysql

Question

Im new to mysql (coming from JS) and I would like to know how to group values for a column in a table (Like in JS you would make an array of strings)? I have this code so far, which throws an error:

CREATE TABLE phone (
    type ('home', 'office', 'mobile')
 );

I need to have the name of the column as "type" and either one of those values - 'home', 'office' or 'mobile'. Thanks!

question from:https://stackoverflow.com/questions/65932746/grouping-values-for-a-column-in-mysql

Answer 1

I think what you want to do, is define the column named type as enum. So the values of your column can only be one of the listed values ('home', 'office', 'mobile'). Documentation for MySQL: https://dev.mysql.com/doc/refman/8.0/en/enum.html
Documentation for MariaDB: https://mariadb.com/kb/en/enum/

This code should work on both systems:

CREATE TABLE phone (
    type ENUM('home', 'office', 'mobile')
);