MySQL 联合查询未返回预期结果，

Question

MySQL 查询只返回联合中的第二个 SELECT 结果，我不知道为什么......你能帮忙吗？

$query  = "SELECT name ";
$query .= "FROM nutrients ";
$query .= "WHERE name LIKE '%{$sqlsafe_query}%' ";
$query .= "LIMIT 30 ";
$query .= "UNION ALL ";
$query  = "SELECT name ";
$query .= "FROM supplements ";
$query .= "WHERE name LIKE '%{$sqlsafe_query}%' ";
$query .= "LIMIT 30";

Answer 1

$query  = "SELECT name ";

你缺的是. =之前