OLDTABLE过渡表保存了受影响的行在被update或delete语句处理之前的初始状态。
The old table transition table holds the original state of the affected rows before they are processed by the UPDATE or DELETE statement.
这一处理将生成一个复制的sql . ddl文件,其中包含您用来在MySQL内创建相应表的语句(您将在稍后执行这一步骤)。
This process yields a file dubbed sql.ddl, which consists of the statements you need to run to create a proper table inside of MySQL (a step you'll perform later).
表7展示了solidDBRETURN SQLERROROF cursorname 语句的使用,与DB2 中的异常处理形成对比。
Table 7 shows the use of the solidDB RETURN SQLERROR OF cursorname statement compared to exception handling on DB2.
为应用程序堆、语句堆、缓冲池和临时表空间这些区域中的本地处理调优联邦系统。
Tune the federated system for local processing in the areas of application heap, statement heap, buffer pool, sort heap, and temp tablespace.
异构批处理能够潜在地提高在多个表上对语句进行INSERT、UPDATE和DELETE操作时的性能。
Heterogeneous batching can potentially improve the performance on INSERT, UPDATE and DELETE statements that operate on multiple tables.
对于表3左侧列的DB 2示例,如果某条sql语句失败并生成一个错误,那么控制将被传递给条件处理程序。
In the case of the DB2 example in the left column of Table 3, if a particular SQL statement fails and generates an error, control is passed to the condition handler.
如果想要收集将要在多个表上执行的一系列SQL操作,JDBC不支持对这些语句进行批处理。
If you wanted to collect a set of SQL operations that was going to act on more than one table, JDBC does not support batching those statements.
这种形式的批处理仅限于单个表以及同一sql语句的多个执行,前提是该语句有输入参数。
This form of batching is restricted to single tables and to multiple executions of the same SQL statement as long as the statement has input parameters.
JDBC支持收集将要引用一个表的sql语句并批量处理语句集合。
JDBC supports collecting SQL statements going to one table and executing the set of statements in batch.
这里展示的任务可能是微不足道的,但它也能轻松处理跨多个表、执行触发器等的SQL语句。
The task here may have been trivial, but this could just as easily have been an SQL statement that spanned multiple tables, executed triggers, and so on.
现在,处于try错误处理语句中,继续从Excel工作簿收集信息,我们先从它的工作表开始。
Now, staying within the try error handling statement, proceed to gather information from the Excel workbook, starting with its sheets.
如果处理大型的xml词汇表,您可能会发现在回调方法中有大量的if和else语句。
If you process large XML vocabularies, you may find yourself with a large number of if and else statements in your callback methods.
预处理模块用来对语句表进行预处理和封装。
Preprocessing module is used to pre-process and package instruction.
仅在支持sql语句批处理的数据库上才支持刷新数据表。
Refreshing the data table is only supported on databases that support batching of SQL statements.
需要考虑的另一方面是,派生表需要被显式 处理,尽管只是执行EXPLAIN语句。
One more thing to watch for is the fact derived table is going to be materialized even to execute EXPLAIN statement.
需要考虑的另一方面是,派生表需要被显式 处理,尽管只是执行EXPLAIN语句。
One more thing to watch for is the fact derived table is going to be materialized even to execute EXPLAIN statement.
应用推荐