Mysql如何存储文本文件

夏洛特猫

本人刚接触数据库存储，对于文本文件存储MySQL中的方法还是不太明白，希望各位大牛给予指点。
目标是将一个文本文件的路径存储到mysql数据库中，之后查询数据库中存储的路径就可以找到这个文本文件，开始想将文本文件的内容整体存到数据库中，但一是不知道这种非结构化的文件建立什么样的表单存储，之后看到很多人说把目标数据的路径存储到mysql中就可以，感觉这个方法好也节省空间，
但是不太清楚怎么建立目标文件的所在路径，如何将所在路径存储到mysql中，如何查找这个路径。
希望各位大牛给科普下

假设目标文件路径在/home/L/ldl
目标文件名是ldl
文件ldl内容：
orking slaves lake lake lake lake shadow online mouth ministries block block funds empire empire empire empire empire empire empire empire english english english english english english english foreign foreign foreign foreign foreign foreign foreign kuchi ones ones york york york southern southern southern southern ethnic ethnic ethnic women women women women women women services services services services whom became became became became became him him him him him him him him hit his his his his his his his his his his his his his his his his his his his his his his his his his his his his his his his his his yavanas wdistrict district district district district italy italy italy italy annual mountain mountain mountain mountain mountain out out out out out out out good fellow notable notable تصنيف

如何将目标文件的目录存储到mysql中，之后再mysql中通过查询这个路径找到/home/L/ldl 这个文件并显示内容

asdf2110

你说的这个是 Oracle 的BFILE 吧，存储一个 URL 到数据库中
mysql 存这种文本用 text，longtext 等

夏洛特猫

说先谢谢您的回复，我目前只需要用mysql存储数据跟前端基本没有关系，所以您说的存储url路径之后再放到mysql中以供查询，能具体说下操作吗 多谢了。回复 2# asdf2110


   

seesea2517

回复 3# 夏洛特猫


    二楼的意思是你存储文件内容到数据库中，不存储文件目录，这时候在系统里没有实际的文件了。
如果你要存储目录，再去找文件，一般的实现是由服务端程序（php之类的）读取数据库得到目录后，由服务端程序来访问该目录得到文件内容。

夏洛特猫

好的多谢回复 4# seesea2517