带输入或输入IN标签的HTML5结构标签(HTML5 structure label with input OR input IN label)
哪一个更合适?
第一:
<div> <label for="male">Male</label> <input type="radio" name="gender" id="male" value="male"> </div>
第二个:
<label for="male">Male <input type="radio" name="gender" id="male" value="male"> </label>
他们也在工作,但我不确定第二个选项是否适用于所有html结构。
which one is more appropriate?
First one:
<div> <label for="male">Male</label> <input type="radio" name="gender" id="male" value="male"> </div>
Second one:
<label for="male">Male <input type="radio" name="gender" id="male" value="male"> </label>
They're working as well, but i'm not sure if the second option is good with all html structures.
原文:https://stackoverflow.com/questions/39615818
最满意答案
那这个呢?
SELECT ... , @var1 = MAX(IF(table1.name='Mod', table1.value, NULL)) , @var2 = MAX(IF(table1.name='Man', table1.value, NULL)) , CASE WHEN @var1 IS NOT NULL && @var2 IS NOT NULL THEN @var1+"/"+@var2 WHEN @var1 IS NULL && @var2 IS NOT NULL THEN @var2 WHEN @var1 IS NOT NULL && @var2 IS NULL THEN @var1 ELSE NULL END AS "col44"
请注意添加逗号和删除括号。
或者,您可以使用子查询。 (根据我的经验,查询中的变量在与聚合一起使用时可能变得不可预测;这完全避免了这些变量)。
SELECT ... , CASE WHEN modMax IS NOT NULL && manMax IS NOT NULL THEN modMax+"/"+manMax WHEN modMax IS NULL && manMax IS NOT NULL THEN manMax WHEN modMax IS NOT NULL && manMax IS NULL THEN modMax ELSE NULL END AS "col44" FROM ( SELECT ... , MAX(IF(table1.name='Mod', table1.value, NULL)) AS modMax , MAX(IF(table1.name='Man', table1.value, NULL)) AS manMax ... ) AS subQ
附加说明:小心
modMax+"/"+manMax
; 它最终会给你一个从modMax + 0 + manMax计算出来的整数,而不是一个字符串。What about this?
SELECT ... , @var1 = MAX(IF(table1.name='Mod', table1.value, NULL)) , @var2 = MAX(IF(table1.name='Man', table1.value, NULL)) , CASE WHEN @var1 IS NOT NULL && @var2 IS NOT NULL THEN @var1+"/"+@var2 WHEN @var1 IS NULL && @var2 IS NOT NULL THEN @var2 WHEN @var1 IS NOT NULL && @var2 IS NULL THEN @var1 ELSE NULL END AS "col44"
Note the addition of commas, and removal of parenthesis.
Alternatively, you could just use a subquery. (In my experience, variables in queries can become unpredictable when used in conjunction with aggregation; this avoids the variables altogether).
SELECT ... , CASE WHEN modMax IS NOT NULL && manMax IS NOT NULL THEN modMax+"/"+manMax WHEN modMax IS NULL && manMax IS NOT NULL THEN manMax WHEN modMax IS NOT NULL && manMax IS NULL THEN modMax ELSE NULL END AS "col44" FROM ( SELECT ... , MAX(IF(table1.name='Mod', table1.value, NULL)) AS modMax , MAX(IF(table1.name='Man', table1.value, NULL)) AS manMax ... ) AS subQ
Additional note: Watch out for
modMax+"/"+manMax
; it may end up giving you an integer calculated from modMax+0+manMax, instead of a string.
相关问答
更多-
有什么数据库专业书籍介绍?[2022-05-19]
mysql -
如果它是一个标量子查询(即,您在SELECT或WHERE子句中使用,而不是在FROM子句中),则使用下面的代码: IF( EXISTS ( SELECT NULL FROM sample_table t WHERE t.user_id = 2 AND t.group_id = 12 ), 'yes', 'no' ) 甚至是这样: COALESCE( ( SELECT 'yes' FROM sample_table t WHERE t.user_id = 2 ...
-
去除=运算符周围的空格: case "$flag" in H) host="$OPTARG" ;; w) warning="$OPTARG" ;; c) critical="$OPTARG" ;; esac Remove the spaces around the = operators: case "$flag" in H) host="$OPTARG" ;; w) warning="$OPTARG" ;; c) critical="$OPTARG" ;; esac
-
如果我没有弄错,编译器应该给出一个错误: 类型'UIViewController'的值没有成员'menuType' 在这里你有几个选择来解决这个问题: 解决方案1 使用铸造 @objc func menuButton(sender: UIButton) { var view: UIViewController! switch sender.tag { case 0: view = MenuViewController() (vi ...
-
我认为你的目标是这样的: #!/bin/bash # Print usage message: usage() { echo "Usage: $0 [-n N] [-t|-p] INPUT OUTPUT" >> /dev/stdout } # Set default values n_threads=1 use_threads=1 while getopts "n:pth" opt; do case $opt in n) n_threads=$OPTARG;; t) use_th ...
-
那这个呢? SELECT ... , @var1 = MAX(IF(table1.name='Mod', table1.value, NULL)) , @var2 = MAX(IF(table1.name='Man', table1.value, NULL)) , CASE WHEN @var1 IS NOT NULL && @var2 IS NOT NULL THEN @var1+"/"+@var2 WHEN @var1 IS NULL && @var2 ...
-
尝试 WHEN (COL3 = '0' AND NOT (COL1 = '0' OR COL2 = '0')) ... WHEN (COL2 = '0' AND NOT (COL1 = '0')) ... WHEN COL1 = '0' ... 所以只有想要的才是真的 Try WHEN (COL3 = '0' AND NOT (COL1 = '0' OR COL2 = '0')) ... WHEN (COL2 = '0' AND NOT (COL1 = '0')) ... WHEN COL1 = '0' ...
-
第一个版本的问题是字符串中的事物引用。 例如,您希望您的字符串包含“'Book'” select concat('insert into x values(', (CASE a when 'B' then '''Book''' else '''NONE''' end) , ') on duplicate key update B = values(''B'')' ) from author; 我认为这引用了它们应该是的字符 ...
-
您已将constant1定义为函数。 当你尝试在模式匹配中使用它时,Elixir期望变量存在并且你有一个错误。 无法模式匹配功能。 您可能想要的是: defmodule Main do constant1 = 1 constant2 = 1 constant3 = 1 x = 1 y = 0 z = 0 {a, b, c, d} = case {x, y, z} do {^constant1, ^const ...
-
为什么在Excel VBA中的case语句中不访问变量(Why variable is not accessed inside a case statement in Excel VBA)[2022-03-29]
你的代码适合我。 因为你想要在前10行中翻阅你必须在开头设置counter = 0,或者根本不设置它,你可以缩短它: Private Sub Button2_Click() Dim mark As Single Dim grade As String Dim counter As Integer Range("A1:B10").HorizontalAlignment = xlCenter Do While counter < 10 counter = ...