mysql - "where 1=1"声明

Question

这个问题在这里已经有了答案:

关闭 10年前.

Possible Duplicate:
Why would someone use WHERE 1=1 AND <conditions> in a SQL clause?

我看到有人使用如下语句查询 MySQL 数据库中的表:

select * from car_table where 1=1 and value="TOYOTA"

但是这里的 1=1 是什么意思？

Answer 1

这通常是人们构建 SQL 语句的时候。

当您添加 and value = "Toyota" 时，您不必担心之前是否有条件或只是 WHERE。优化器应该忽略它

没有魔法，只有实用

---

示例代码:

commandText = "select * from car_table where 1=1";

if (modelYear <> 0)     commandText += " and year="+modelYear
if (manufacturer <> "") commandText += " and value="+QuotedStr(manufacturer)
if (color <> "")        commandText += " and color="+QuotedStr(color)
if (california)         commandText += " and hasCatalytic=1"

否则你将不得不有一套复杂的逻辑:

commandText = "select * from car_table"
whereClause = "";
if (modelYear <> 0)
{
   if (whereClause <> "") 
      whereClause = whereClause + " and ";
   commandText += "year="+modelYear;
}
if (manufacturer <> "")
{    
   if (whereClause <> "") 
      whereClause = whereClause + " and ";
   commandText += "value="+QuotedStr(manufacturer)
}
if (color <> "")
{
   if (whereClause <> "") 
      whereClause = whereClause + " and ";
   commandText += "color="+QuotedStr(color)
}
if (california)
{
   if (whereClause <> "") 
      whereClause = whereClause + " and ";
   commandText += "hasCatalytic=1"
}

if (whereClause <> "")
   commandText = commandText + "WHERE "+whereClause;