MySQL Database Tutorial - 1 - Introduction to Databases
Why Stack Overflow recommends it
Stack Overflow users link it when an asker seems new to databases and needs a gentle starting point before they can follow an answer about tables, schemas or queries.
Recommended by 4 people across 4 different months, 2013 to 2017.
What it is
A short beginner video from thenewboston (Bucky Roberts) that opens his MySQL tutorial series by explaining what a database is and why you would use one. It is the first of many episodes aimed at people with no database background.
What people said
Recommends Kamil · 2013-01 · Stack Overflow · on “auto sync two mysql tables with exception”
You dont have to use cron. MySQL in current version supports TRIGGERS and EVENTS . You can use TRIGGER to copy data to another table. That copy (or any other operation) may be triggered by some event (like insert, update or delete in table). TRIGGER may run any query or any PL/SQL code. Other option is an EVENT . This is something like internal task sheduler built in MySQL. It can also run queries, or any PL/SQL code, but it is triggered by system time (like Linux Cron). It has many advantages compared to cron. PL/SQL is procedural SQL, with loops, variables and more. If you think you are "noob" - i have cure for you. Read books about MySQL or if you are lazy - watch some tutorials ( [LINK]
Recommends CodeFanatic · 2014-08 · Stack Overflow · on “How to Store multiple values in same SQL column”
By reading your Question, I realized, from my point of view, that your skills may not be good enough to do and to understand what you want to do. So I´d like to suggest you to watch this [this video] Tutorial by Bucky Roberts on YouTube and to read this [LINK] Wikipedia Article about Data Redundancy. Anyways to answer your Question. I would not store answers and questions all in a single table column. Think about creating a second table called 'answers', give an ID to the answers and connect them with the table'questions'. This is called the Foreign Key Concept. You can read about it here [LINK] .
Recommends Renuka Deshmukh · 2016-03 · Stack Overflow · on “Create a schema in mysql using a script”
Here [this video] is a mysql tutorial for beginners. It should help. I find videos help more than reading about it.
Recommends Red_Spark · 2017-08 · Stack Overflow · on “How do I save a custom class object data model to a different file each time it is made in java?”
If you don't know how databases work you should read up about them or watch this: [this video] Once you understand databases, tables, and queries, the link I gave you before should be sufficient to help you build it in android.