数据库结构-如何判断是否有新回复
数据库结构--怎么判断是否有新回复？
数据库结构--怎么判断是否有新回复？
如我在这里发了贴，人家回复了我的帖子，我进入帖子中心，这个帖子会高亮显示，我点击浏览这个帖子后，这个帖子就变成普通非高亮状态，请问数据库结构应该是怎样的？
------解决方案--------------------
设一字段：
初值为一
回复加一，浏览减一
列表时判断一下即可
------解决方案--------------------
表里加个字段，递增就行，有回复就加一
------解决方案--------------------
被一个字段，update_time 数据库设一下，更新时，记录最近更新时间！
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
AI Hentai Generator
Generate AI Hentai for free.
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
Fix: Google Chrome update check failed with error code 3: 0x80040154
Apr 13, 2023 pm 05:46 PM
Google Chrome is one of the most popular browsers in the world and many users prefer to use it as the default browser on their Windows PCs. Chrome offers a wide range of features that make the browsing experience enjoyable and effortless, and therefore, it remains one of the most trusted browsers. But just like any other browser, even Chrome has its own shortcomings, and it's equally prone to bugs and glitches when you need it most. One such error is Error Code 3: 0x80040154, which occurs while checking for Google Chrome updates. The error message reads "An error occurred while checking for updates. The update check failed to start (Error code 3: 0x80080005) or (Error
How to enable/disable VS Code automatic updates
Apr 28, 2023 am 09:28 AM
If you are using Visual Studio Code (VSCode) and thinking about how to disable its automatic software updates and how to disable the automatic updates of its extensions, then read this article. If you don't use VSCode often, open the editor after a long period of time and want to enable automatic updates, this article will also guide you in doing so. Let us discuss in detail the different ways to enable or disable VSCode automatic updates. Table of Contents Method One: Use Settings to Enable/Disable VSCode Automatic Updates Step 1: Open VS Code and click the gear-shaped symbol in the lower left corner. Step 2: Click Settings in the list that appears. Step 3: Type update in the search bar and hit enter. Find Updates: Pattern 4
Monotonic clock processing of time package
Aug 04, 2023 pm 05:45 PM
Today we are mainly going to take a look at the time application method of golang time package. The general rule between the two is that "wall time" is used to tell time, and "monotonic clock" is used to measure time; there are other clock processing methods.
Solution to high CPU usage of Microsoft compatibility telemetry
Mar 16, 2024 pm 10:16 PM
When we use the win10 system, we sometimes encounter situations where the computer becomes stuck. Then when we check the background process, we find that a Microsoftcompatibilitytelemetry process takes up a particularly high amount of resources. So what is going on? Users can try to uninstall the third-party protection software and then try a clean boot to operate. Let this site carefully introduce to users the solution to the high CPU usage of Microsoftcompatibilitytelemetry. Solution to the high CPU usage of Microsoftcompatibilitytelemetry Method 1: Try after uninstalling the third-party protection software
KDE Plasma 6.1 brings many enhancements to the popular Linux desktop
Jun 23, 2024 am 07:54 AM
After several pre-releases, the KDE Plasma development team unveiled version 6.0 of its desktop environment for Linux and BSD systems on 28 February, using the Qt6 framework for the first time. KDE Plasma 6.1 now comes with a number of new features t
How to use UPDATE statement in SQL
Jun 02, 2023 pm 09:13 PM
SQLUPDATE statement The Update statement is used to modify the data in the table. The syntax is as follows: UPDATE table name SET column name = new value WHERE column name = certain value "Person" table: LastNameFirstNameAddressCityGatesBillXuanwumen10BeijingWilsonChamps-Elysees Update a column in a certain row UPDATEPerson SETFirstName="Fred" WHERELastName="Wilson" Result: LastNa
In-depth exploration of the usage details of UPDATE in MySQL
Oct 11, 2022 pm 07:32 PM
In MySQL, you can use the UPDATE statement to modify and update data in one or more tables. The following article will help you explore the details of the use of UPDATE in MySQL. I hope it will be helpful to you.
Fitbit Ace LTE receives major update with new games, contactless payment and other features
Aug 08, 2024 pm 09:39 PM
The Fitbit Ace LTE was officially launched in May, but is currently only available in the US. The smartwatch is aimed specifically at children, who can receive rewards for games through a more active lifestyle, while parents can always monitor their
