Home >Backend Development >PHP Tutorial >Mysql条目限制
Mysql条目限制
- WBOYOriginal
- 2016-06-06 20:50:011294browse
某音乐搜索程序，soundcloud的API，用户每搜索一次，就会有一首歌入库。
<code>mysql_query("INSERT INTO songs (s_id,name,artwork,views,favorites,duration,genre,owner,descr,download) VALUES ($id,'$name','$artwork',$views,$favorites,'$duration','$genre','$owner','$descr','$download')");
</code>
才一周数据库就到500M+了，怎么限制数据库条目为10？
回复内容：
某音乐搜索程序，soundcloud的API，用户每搜索一次，就会有一首歌入库。
<code>mysql_query("INSERT INTO songs (s_id,name,artwork,views,favorites,duration,genre,owner,descr,download) VALUES ($id,'$name','$artwork',$views,$favorites,'$duration','$genre','$owner','$descr','$download')");
</code>
才一周数据库就到500M+了，怎么限制数据库条目为10？
1.先count，再delete，再insert 2.存储过程
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：文件中的空字符串如何回车换行？Next article：为嘛配置php环境变量，在命令运行窗口，执行php命令，还报错。