假设我有3张表:
p、r和l
我想选择每个表中有多少行,并将它们定义为表名的变量。
$sevenQ = mysql_query("SELECT count(*) FROM `p` AS p WHERE `added` LIKE '" . $today . "%' union
SELECT count(*) FROM `r` AS r WHERE `added` LIKE '" . $today . "%' union
SELECT count(*) FROM `l` AS l WHERE `added` LIKE
我想将这四个查询合并为一个:
SELECT COUNT(ID) FROM conversations WHERE DAY(create_time)=DAY(NOW());
SELECT COUNT(ID) FROM conversations WHERE WEEKOFYEAR(create_time)=WEEKOFYEAR(NOW());
SELECT COUNT(ID) FROM conversations WHERE MONTH(create_time)=MONTH(NOW());
SELECT COUNT(ID) FROM conversations WHERE YEAR(create_
我在MySQL中运行如下所示的SQL查询:
select *
from (
select 2 as o,1 as t from dual
union
select 1 as o,2 as t from dual
) x
order by if((select 1),o,t);
它工作得很好,但是当我在if语句中使用列相对位置时,它就不工作了。
如何在ORDER BY语句中使用if中的列相对位置?
select *
from (
select 2 as o,1 as t from dual
union
select 1 as
我希望在我的查询中有三组行,每组100行。每个集合具有不同的数据值。所以就像这样:
$result = mysql_query("SELECT * FROM actions WHERE appid='$appid' AND email!='' AND user_name!='' AND data='24' ORDER BY count DESC LIMIT 100") or die(mysql_error());
$result .= mysql_query("SELECT * FROM actions W
人民
这是我的小问题。我有三个表: a_names_1,b_names_2,c_names_3,它们在结构上是一样的。它们都有两个项目:名称和使用
有没有需要运行的查询,以便从所有这三个表中获取和计算所有“已用”=1的“名称”。
我试过这个,但不起作用:
(SELECT COUNT(*) 'name' from a_names_1) UNION
(SELECT COUNT(*) 'name' from a_names_2) UNION
(SELECT COUNT(*) 'name' from a_names_3) WHERE `used`=1
mysql> select count(id) total from applicants;
+-------+
| total |
+-------+
| 0 |
+-------+
1 row in set (0.00 sec)
mysql> select count(id) total from jobs;
+-------+
| total |
+-------+
| 0 |
+-------+
1 row in set (0.00 sec)
mysql> select count(id) total from applicants union s
我使用了以下查询,用于生成mysql表中没有的随机值。
SELECT FLOOR( RAND()*1000 + 50 ) AS temp FROM tempcode WHERE 'temp' NOT IN ( SELECT code FROM tempcode ) LIMIT 1
但是当我将值减少到RAND()*4以用于检查目的时,使用的是不起作用的虚拟数据。
SELECT FLOOR( RAND()*1000 + 50 ) AS temp FROM tempcode WHERE 'temp' NOT IN ( SELECT code FROM tempco
我有一个包含项目数据的数据库表,每个项目都有一条记录。在下面的一些样本数据中,持续时间以月为单位,目前限制为最大。240,但理论上可以是无限的:
id name amount start_date duration
1 Project A 9.000 2013-06-24 3
2 Project B 5.000 2013-07-13 2
3 Project C 15.000 2013-08-06 3
现在,我希望MySQL返回每个项目的每月金额:金额除以从start_date所在的月份开始的每个月的持续时间。因此,基于以上数据,M
下面的错误,所以肯定是错的,但是正确的做法是什么呢:
$query = "SELECT * FROM tblProducts WHERE ProductId ='$SCId' AND SELECT * FROM tblProducts WHERE Cat ='$CatType' AND Type ='$TypeType'";
$rsPrimary = mysql_query($query)或die (“查询'$query‘失败,错误消息:\"”. mysql_error () . '"');
我有一个MySQL查询,我想对其进行一些优化。这就是它:
SELECT `items`.category AS 'Category', 'Without' AS 'Which', COUNT(*) AS 'Count'
FROM `items`
WHERE `id`=706
GROUP BY `category`
UNION
SELECT `items`.category AS 'Category', 'With' AS 'Which', COUNT(*) AS 'C
我有一个预订表,需要在MYSQL中找到特定日期范围内的预订计数。但是它只给了我非空值。我需要在select查询中将范围内的不存在日期显示为NULL。下面是我的问题:
SELECT DATE_FORMAT(booking_created_on, '%b %e') AS dateValue , COUNT(booking_id) AS cnt FROM booking WHERE booking_created_on BETWEEN '2016/02/01' AND '2016/02/08' GROUP BY booking_created_on
我
我在mysql中有联合表,但我需要获取名称表来显示我的数据。下面是mysql代码
$blog = mysql_query("SELECT gambar FROM life
UNION ALL
SELECT gambar FROM places
UNION ALL
SELECT gambar FROM style
UNION ALL
SELECT gambar FROM art
order by RAND() ");
然后在php中他们显示,但我有问题的图像,因为图像在不同的文件夹中的表名在这里我的php代码
$tes = mysql_query("SELECT ga
如果我需要从products和subcontent表中获取行,那么需要编写什么样的查询,image_id字段与$id匹配
图像表
mysql> show columns from images;
+-----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+----------
if($result = mysql_query(
"SELECT `condition` FROM `table1` WHERE `id` = '1')
UNION ALL
SELECT `condition` FROM `table2` WHERE `id` = '1')
UNION ALL
SELECT `condition` FROM `table3` WHERE `id` = '1')"
){
$num = mysql_num_rows($result);
for($i = 0; $i &
我有大约5个具有公共字段“userid”的表,我想在所有这些表中计算不同的userid。某些用户ids可能出现在这些表中的大约2个表中。但是我想要将5个表中不同用户in的联合计数在一起。我可以使用ff代码在一个表中计算不同的userid。我希望能够从所有的表中计数。
//just count the nuber of distict userids in table1
$query2 = ("SELECT COUNT(DISTINCT userid) FROM table1");
$result2 = mysql_query($query2) or die(m
Mysql版本5.1。代码示例:
mysql_query("SELECT * FROM abonents WHERE `session_id`='$current_sess_id' UNION SELECT * FROM abonents_problem WHERE `session_id`='$current_sess_id' UNION SELECT * FROM abonents_stop WHERE `session_id`='$current_sess_id'");
运行如果删除"UNION",例如:
m
我知道有sql查询将计数从1打印到10,如下所示:
select rownum from dual where rownum<=10;
以同样的方式,我尝试在mysql中,但它抛出错误“未知列rownum In field list”。所以,如果有人给我提供mysql查询来执行同样的操作,那就太好了。提前谢谢。