[Abid Rizvi]

I have the Database Schema (see attached image db_schema.png)

 

I have created the output form as (add-questions.png)

 

I want to save this into DB  field "choices"?

 

 

[Paul Savostin]

Hi! You doing wrong, for field choices you need to use ENUM type, that's it

[Abid Rizvi]

Hi,

Thanks for your response. But I want to save  a custom value with True and False of it. I am making a quiz.

In ENUM we can have only predefined values.

Do you have any suggestion for custom values of choice with its True/false value?

[Paul Savostin]

Hi! Plan your database schema in the rigth way! No one database type would'n be good for your situation.

I think you need put "answers" to another table and make one-to-many relationship between questions and answers (primary_id, answer (text), condition(boolean), question_id)

For example first method will be the list of questions and second - list of answers by question ID.

Then you easily can add more then 4 answers per question, change answers order and so on. And this is wiil be the normal databse designing.

Hope it helps.