使用筛选器(例如sql子句)筛选掉不属于当前租户的数据记录。
A filter (e.g., SQL statement sub-clause) is used to filter out data records not belonging to the current tenant.
如果该子句未指定任何内容,那么可以提取来自实例中任何数据库的审计记录。
If you do not specify anything for this clause, audit records from all databases in the instance are eligible for extraction.
事情还没有完结,如果数据提供者是一个SQL数据库的话,WHERE子句必须应用在每条记录上。
But we're not done yet. If the data provider is an SQL database, the WHERE clause must be applied to each record.
如果数据提供程序是一个SQL数据库,则必须将where子句应用于每条记录。
If the data provider is an SQL database, the WHERE clause must be applied to each record.
通过database子句可以限制只提取一个特定数据库中的记录。
The database clause allows you to limit record extraction to a particular database.
与任何数据库update查询一样,您必须向YQL查询传递要更新的字段列表,以及其新值和将更新限制为一组记录的一个where子句。
As with any database update query, you must pass the YQL query a list of fields to be updated, together with their new values, and a WHERE clause that restricts the update to a set of records.
通常情况下,原始值用作where子句中的参数以标识数据库中的记录,而当前值则用于SET或values子句中。
Typically, the original value is used as a parameter in a WHERE clause to identify the record in the database, and the current value is used in SET or VALUES clauses.
通常情况下,原始值用作where子句中的参数以标识数据库中的记录,而当前值则用于SET或values子句中。
Typically, the original value is used as a parameter in a WHERE clause to identify the record in the database, and the current value is used in SET or VALUES clauses.
应用推荐