主页 / user-642180

Лена's questions

Martin Hope
Лена
Asked: 2024-10-26 22:49:39 +0800 CST
  • 5

.g {
  display:flex;
  height:50px;
  width:100%;
  background: green;
}
.l {
  height:100%;
  aspect-ratio:1;
  background: red;
  margin-right:auto;
}
.r {
  height:100%;
  aspect-ratio:1;
  background: blue;
}
<div class='g'>
  <div class='l'>L</div>
  <div class='r'>R</div>
</div>

.g {
  display:flex;
  height:50px;
  width:100%;
  background: green;
}
.l {
  height:100%;
  aspect-ratio:1;
  background: red;
  margin-right:auto;
}
.r {
  height:100%;
  aspect-ratio:1;
  background: blue;
}

.C {
  height:100%;
  aspect-ratio:1;
  background: #000;
  color:#fff;
  margin: 0 auto;
}

.l {
   margin:unset;
}
<div class='g'>
  <div class='l'>L</div>
  <div class='C'>C</div>
  <div class='r'>R</div>
</div>

当中间出现一个方块时，需要修复左边

.l {
   margin:unset;
}

否则，中心块将不会居中。

问题是是否可以通用，这样你就不必再次修复左侧的块。

最初在左侧块

margin-right:auto;

否则右边的方块不会被压到右边缘...

html
Martin Hope
Лена
Asked: 2024-10-26 13:47:30 +0800 CST
  • 5
SELECT t1.*,
COUNT(CASE WHEN t2.time >= UNIX_TIMESTAMP() - 86400)  AS 24_hours,
COUNT(CASE WHEN t2.time >= UNIX_TIMESTAMP() - 172800) AS 48_hours,
COUNT(CASE WHEN t2.time >= UNIX_TIMESTAMP() - 259200) AS 72_hours
FROM table1 AS t1
LEFT JOIN table2 AS t2 ON t2.t1_id = t1.id

这不起作用，我正在尝试计算，添加 3 个字段，每个字段 3 个时间段。我们需要计算第二个表中的记录数......

mysql