通过标签来检索内容,该如何设计数据库。
比如一篇文章被标记了多个标签,情感,小清新,生活。也就是一篇文章对应多个标签,这样我是做成一篇文章id 对应一篇文章标签id好 还是一篇文章id 对应多个标签id加,连接好?我在考虑文章多了,第一种方式是不是记录就太多了?比如1百万文章,可能有几百万条记录
也就是
1 1
1 2
1 3
1 4
还是
1 1,2,3,4
还有第二种方式 检索是不是很慢?
回复内容:
比如一篇文章被标记了多个标签,情感,小清新,生活。也就是一篇文章对应多个标签,这样我是做成一篇文章id 对应一篇文章标签id好 还是一篇文章id 对应多个标签id加,连接好?我在考虑文章多了,第一种方式是不是记录就太多了?比如1百万文章,可能有几百万条记录
也就是
1 1
1 2
1 3
1 4
还是
1 1,2,3,4
还有第二种方式 检索是不是很慢?
第二种我觉得更好,但是为了保证速度,你要为你的数据库里面的tid字段添加全文索引。
加入你的表明叫article,分类字段叫tid。那么你就要为你的字段添加索引。
<code>ALTER TABLE article ADD FULLTEXT (tid); </code>
如果你要查询的tid是1,4,9,25 当你要查询的时候,就这么做:
<code>SELECT * FROM article WHERE MATCH(tid) AGAINST('1 4 9 25'); </code>
极目楚天舒的全文检索能利用索引,确实也是个别出心裁的方法.
另外楼主也可以试试用MySQL的函数FIND_IN_SET:
比如 SELECT FIND_IN_SET('b','a,b,c,d')
将返回2.
比如查询指定标签'php'下的文章:
用FIND_IN_SET可以这样:
<code>SELECT * FROM `posts` WHERE FIND_IN_SET('php', `tags`); </code>
用MATCH AGAINST可以这样:
<code>SELECT * FROM `posts` WHERE MATCH(`tags`) AGAINST('php'); </code>

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.

PHP is suitable for web development and rapid prototyping, and Python is suitable for data science and machine learning. 1.PHP is used for dynamic web development, with simple syntax and suitable for rapid development. 2. Python has concise syntax, is suitable for multiple fields, and has a strong library ecosystem.

PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields.

PHPhassignificantlyimpactedwebdevelopmentandextendsbeyondit.1)ItpowersmajorplatformslikeWordPressandexcelsindatabaseinteractions.2)PHP'sadaptabilityallowsittoscaleforlargeapplicationsusingframeworkslikeLaravel.3)Beyondweb,PHPisusedincommand-linescrip

PHP is suitable for web development and content management systems, and Python is suitable for data science, machine learning and automation scripts. 1.PHP performs well in building fast and scalable websites and applications and is commonly used in CMS such as WordPress. 2. Python has performed outstandingly in the fields of data science and machine learning, with rich libraries such as NumPy and TensorFlow.

What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends.

MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.

Oracle is not only a database company, but also a leader in cloud computing and ERP systems. 1. Oracle provides comprehensive solutions from database to cloud services and ERP systems. 2. OracleCloud challenges AWS and Azure, providing IaaS, PaaS and SaaS services. 3. Oracle's ERP systems such as E-BusinessSuite and FusionApplications help enterprises optimize operations.
