Enums are weird #database #mysql #coding

Показать описание

Enums are great for listing out specific choices because they give you the readability of a string but the underlying storage of an integer. There are a few gotchas though!

PlanetScale

Рекомендации по теме

Комментарии

What in the JavaScript is happening here?😂

milesstripling

I never use enums because adding new ones or redefining them is a total pain. It's a lot easier to do this at the application layer

spicynoodle

You can refer this col in queries using the underline integer value instead the of the string value that's the BIG advantage of the ENUMS, as everything in code, so that later you can change the string value without affect the written code.
Thanks

MrNiceGuy

Yes, Enums in MySQL is a total mess and it just creates so many problems. Just adding one new option is a pain and that doesn't even work properly with Laravels migrations. It's much better with a varchar + index, or in some cases a tinyint and then manage the constraints in the application layer. You still have to validate the data before inserting so it is not really any additional work.

Pekzr

so to fix that would
max(size+0)
work?

monq

What’s this client software you’re using?

gabrielbianchi

@PlanetScale I have problems with ENUM, that should allow null values. Did you face it as well and do you have any tricks and advice on how to handle it properly?

ArtemKhodos

I’ll keep using type tables instead, thx

SpadeQc

Enums are weird #database #mysql #coding

Enums are weird #database #mysql #coding

Database enums are weird

Why I Don't Like ENUMs in Database

PHP : How can I get enum possible values in a MySQL database?

SQL : enums in SQL Server database

SQL : MySQL select based on ENUM values

How to add ENUM datatype to store enumeration values in MySQL create table statement For SQL Dev

SQL : How to store enum in SQLite database

MySQL : MYSQL Change Enum Values

SQL : How to sort ENUM column in MySQL database?

INT(11) is a lie #database #mysql #coding

TypeScript - What's An Enum?

MySQL : Enum datatype versus table of data in MySQL?

Don't hide your database indexes!

MySQL : MySQL ENUM type vs join tables

MySQL : Why ENUM does not store multiple values in MySQL?

C# : Should I store Enum ID/values in the database or a C# enumeration?

MySQL : How to map a MySQL enum to a Java Enum with JPA?

SQL : How to define ENUM in SQL Server 2005?

Practical Implementation of enum data type in SQL #mysql #sql

Как Работать с ENUM в MySQL? Об этом и многом другом вы узнаете ВСЕГО за 2 минуты!...

SQL : How do i add a column in oracle with Enum values?

Using MySQL to stop freeloaders (in only 8 minutes)

Distributed SQL Tips: Java to PostgreSQL Enums Conversion