You then create the query (in other words, the where clause) and execute the update.
然后我们创建这个查询(换言之,where子句)并执行更新。
Note: This is equivalent to selecting a database column in the where clause of a SQL statement.
注意:这相当于在sql语句的where子句中选择一个数据库列。
Just create the indexes and add the where clause to your SQL select statements, and you are good to go.
只需创建索引并在SQL select语句中添加where子句,就会使用索引。
应用推荐