In the project I am working on, there is a **Booking** table.
- There are 8 types of Bookings.
- I have elected to have just one table
- There are 12 common fields
I could store the rest of the fields as columns, but I am thinking of using JSON storage (which I have never used). It will add complexity to the code (in terms of readability) to split the JSON in the JavaScript application for editing and then recombining.
Can I get MySQL to do the splitting and combining of JSON fields?
Asked by Rohit Gupta
(2126 rep)
Jul 10, 2025, 01:06 PM