The best way to insert tags in a DB

From: ^Bart <gabriele1NOSPAM_at_hotmail.com>
Date: Sat, 19 Oct 2019 22:40:54 +0200
Message-ID: <qofscl$1m0s$1_at_gioia.aioe.org>



[Quoted] Hi everybody! :)

[Quoted] [Quoted] I need to insert in a db tags about food recipes and I thought to start in this way:

recipes


id_recipe 	name
1		hamburger

recipetags


id_recipetag	name
1		meat
2		bread
3		latuce

recipedetails


id_recipedetail	FK_id_recipe	FK_id_recipetag
1		1		1
2		1		2
3		1		3	

[Quoted] Is there a better way to insert tags? I thought I could insert them like this:

recipetags


id_recipetag	name
1		meat
2		bread
3		lettuce

recipes


id_recipe 	name		tags
1		hamburger	meat, bread, lettuce

What do you think about these two ideas? Do you have another one?

Thanks! :)
^Bart Received on Sat Oct 19 2019 - 22:40:54 CEST

Original text of this message