How to create mysql database table for dynamic fields

Question

I want to create database table using mysql for transport application. Here I want to add columns which are not fixed for every record. They are added dynamically for every record. For example, record 1 contains PoliceFees & StateBoundry whereas record 2 does not have these fields. record 3 might have some others fields and so on. So how to design table for such data??

Set default value to NULL, for the fields which may be empty — Thielicious
– Thielicious, Commented Mar 14, 2018 at 14:43
Use JSON data to store the 'optional' values. dev.mysql.com/doc/refman/5.7/en/json.html — ethrbunny
– ethrbunny, Commented Mar 14, 2018 at 14:45

Thiago Martins · Accepted Answer · 2018-03-14 14:56:15Z

1

Dynamic fields and MySQL (relational database)? I think no-SQL is a better solution to your problem.

But if that fields is all known you can create a table with all of them and set as nullable. So you only insert needed data.

answered Mar 14, 2018 at 14:56

Thiago Martins

1192 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create mysql database table for dynamic fields

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related