如何在mysql中的数据库中存储图像和文本

Question

I want to to store recipes in database, the format of the recipes should be a small photo on the top and a text below. Could anyone explain me how the structure should be?

Thanks in advance

Answer 1

I would avoid storing the actual bytes of the image in the database, that's generally a bad idea (See Storing Images in DB - Yea or Nay?). Instead, I would create a simple TEXT field that stores perhaps a Markdown version of your recipe page. This page could include an image tag pointing to your image or just the recipe instructions.