Until the last minutes where you show how to create table with enum, I realized why not using an lookup table other than hard coded it into a create table statement. Well done explantation.
Well... i will try to imagine example... Lets say you have some Invoice status, New, Pending, Partly Paid, Paid... It would be normal to make those statuses as ENUM. But then... after some time, PO come and tell you - You know.. i want to allow Users set some color for every status. And at this point you should convert your ENUM to separate invoice_status table, where you can store color for every status. (Colors can be changeable per User). The only place where i mostly use ENUM is to describe db record_status.
JESUS! I just went and 'looked up ' the look up table video you made, WHO IS THIS PERSON, its like your ghost twin or something did Aliens Body Snatch the real Caleb Curry?
Until the last minutes where you show how to create table with enum, I realized why not using an lookup table other than hard coded it into a create table statement. Well done explantation.
Thank you very much for the explanation. I searched for something about ENUM data type and I came here. I like your presentation. thanks a lot :)
In my experience with large systems i was forced to convert all ENUM to separate tables.
sure, why? shared with us your experience , please?
Well... i will try to imagine example... Lets say you have some Invoice status, New, Pending, Partly Paid, Paid... It would be normal to make those statuses as ENUM. But then... after some time, PO come and tell you - You know.. i want to allow Users set some color for every status. And at this point you should convert your ENUM to separate invoice_status table, where you can store color for every status. (Colors can be changeable per User).
The only place where i mostly use ENUM is to describe db record_status.
@@Oswee thank man :)
Awesonme! I just subscribed... Nice to have the old fashion always useful board and chalk
Thanks for the easy, short, but comprehensive video 🔥
Ty i'm a mexican user, so you're too great and funny to explain, seriously this helps me a lot, greetings from Mexico!
Do you like russian names?
Great video. Thanks for the help!
Very cool Caleb, easy to understand, thank you!
Much better than reading documentation
can you tell me how to apply alter command on enum datatypes in mysql, if i have to change something in it..
Can we called enum is constant values ?
thanks , greetings from Ecuador
Nailed it!
thanks
thank broo!!
and it just started snowing HHAHAHAHAHAHAHAHAH
When i use ENUM do i check the NN(Not Null) box ?
+Nikos Pap you can, if you want to allow yourself or others to not give a value for that column. 😁
Ok mate. Thank you !
JESUS! I just went and 'looked up ' the look up table video you made, WHO IS THIS PERSON, its like your ghost twin or something did Aliens Body Snatch the real Caleb Curry?
Portugal is here to
Represent aqui peepz
hoi joel