最小化对同一表的选择查询 [英] minimize select queries on the same table Mysql

问题描述

我一直在尝试找出如何将这些 php-mysql 查询减少到最低限度。我想写成单个查询来获取所有数据。

I've been trying to figure out how to reduce these php-mysql queries to a minimum. I want to maybe write as a single query which will fetch all the data.

$db_u = mysql_fetch_array(mysql_query("SELECT * FROM u_settings WHERE setting='username'"));
$db_p = mysql_fetch_array(mysql_query("SELECT * FROM u_settings WHERE setting='password'"));
$db_e = mysql_fetch_array(mysql_query("SELECT * FROM u_settings WHERE setting='email'"));
$db_t = mysql_fetch_array(mysql_query("SELECT * FROM u_settings WHERE setting='tag'"));
$db_a = mysql_fetch_array(mysql_query("SELECT * FROM u_settings WHERE setting='active'"));
$db_v = mysql_fetch_array(mysql_query("SELECT * FROM u_settings WHERE setting='version'"));
$db_ti = mysql_fetch_array(mysql_query("SELECT * FROM u_settings WHERE setting='time'"));
$db_wa = mysql_fetch_array(mysql_query("SELECT * FROM u_settings WHERE setting='warn'"));
$data_dis = mysql_fetch_array(mysql_query("SELECT * FROM u_settings WHERE setting='dis'"));

---

执行上述操作有点使公羊陷入困境。

---

Doing the above is kind of bogging down the Ram. Any help appreciated.

检查其他问题都不符合要求。

Checked other questions none fits the bill.

推荐答案

尝试使用 IN 代替这么多的查询

Try IN instead of so many queries

 SELECT * FROM u_settings WHERE setting IN ('username', 'password','email','tag','active','version','time','warn','dis');

这篇关于最小化对同一表的选择查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！