morteza
1 year ago

Using JSON column instead of typical fields

Posted 1 year ago by morteza

As you know, mysql 5.7 provides json fields. What could be down sides of using a data json fields instead of having many nullable fields on a table? Let's say i'm working on a products table which has length, width, height, thickness, margin, ... all in nullable property. I think is better to use json data column instead of using all these nullable columns. But i don't know what could be down sides!

Please sign in or create an account to participate in this conversation.