小鸡炖蘑菇炖小鸡
你好:SQL: "IN" FunctionThe IN function helps reduce the need to use multiple OR conditions.译:IN函数有助于减少OR条件的复合使用。The syntax for the IN function is:译:IN函数的语法:SELECT columnsFROM tablesWHERE column1 in (value1, value2, .... value_n);This SQL statement will return the records where column1 is value1, value2..., or value_n. The IN function can be used in any valid SQL statement - select, insert, update, or delete.译:该SQL语句将返回column1的值是value1, value2..., 或者value_n的记录。IN函数可以用于任何合法的SQL语句中-select, insert, update, or delete。Example #1The following is an SQL statement that uses the IN function:译:下面是一个使用IN函数的SQL语句SELECT *FROM supplierWHERE supplier_name in ( 'IBM', 'Hewlett Packard', 'Microsoft');This would return all rows where the supplier_name is either IBM, Hewlett Packard, or Microsoft. Because the * is used in the select, all fields from the supplier table would appear in the result set.译:这将返回supplier_name为IBM, Hewlett Packard, 或者 Microsoft的所有记录。因为在SELECT中使用了*,supplier表中所有的字段都会显示在结果集中。It is equivalent to the following statement:译:与下面的SQL语句相同:SELECT *FROM supplierWHERE supplier_name = 'IBM'OR supplier_name = 'Hewlett Packard'OR supplier_name = 'Microsoft';As you can see, using the IN function makes the statement easier to read and more efficient.译:正如你所看到的,使用IN函数使语句更容易读并且有更高的执行效率。望采纳!