SQLite Forum

Timeline
Login

3 forum posts by user AlexCR

2021-05-31
21:54 Reply: How to relate a row with more than one topic? See example (artifact: 1d7321358f user: AlexCR)

Thank you!

21:54 Reply: How to relate a row with more than one topic? See example (artifact: 6d43ee5c24 user: AlexCR)

Thank you Tim... that's ok. The problem with that is that the table could be a lot of rows. If I have 1000 quotes and each one contain at least 5 topics, then that table would reach 5000 rows. MYSQL support this with a column format that SQLITE does not support.

20:41 Post: How to relate a row with more than one topic? See example (artifact: 72537e9ca0 user: AlexCR)

Hi there, I'm new here. I want to make more than one association with a row. Example:

'Quotes' table:

id quote 1 A successful man is a fall in love man. 2 Love is happiness. 3 Success consist on hard work.

'Topics' table:

topic idTopic Love 1 Man 2 Success 3

Now, as you can see there are more than one (2 rows) rows with the 'love' topic included. The same for 'success'. How can I made this relation in sqlite?