在您测试编排之前,需要修改数据库查询语句。
Before you can test the orchestration, you have to adjust the database query.
通常,需要从一组已有的数据库查询语句(SQL)实现应用程序构建。
It is often the case that the process of building an application originates from having a set of database query statements (i.e. SQL).
提示:这个函数是用来将一个字符串存储在一个数据库中或数据库查询语句中的。
Tip: This function can be used to prepare a string for storage in a database and database queries.
为了提供数据库应用程序所需的所有查询功能,select语句的能力十分广泛。
To provide all the query functionality required by database applications, the SELECT statement's capabilities are extensive.
最后,配置连接器,编写一个SQL查询语句来将客房预订信息提交给数据库。
Finally, configure a connector and write an SQL query to submit the room-booking information to the database.
数据库查询自身可以变得相当激烈,通常在对大小合理的数据集执行简单的SELECT语句时限定在100%的CPU。
Database queries can become quite intense on their own, often pegging a CPU at 100 percent for doing simple SELECT statement with reasonable size datasets.
查询本地数据库是一个比较慢的过程,特别是,如果您有多行数据或者您需要在多个表之间运行复杂的查询语句。
Querying a local database can be a slow process, especially if you have many rows of data or you need to start running complex queries that join multiple tables.
黑客向文本框中输入不正确的sql语句以更改查询的性质,从而可以使用它入侵、更改或损坏后端数据库。
A hacker enters a malformed SQL statement into the textbox that changes the nature of the query so that it can be used to break into, alter, or damage the back-end database.
此信息可以使用标准sql语句对这些信息进行查询和分析,以用于底层数据库。
This information can be queried and analyzed using standard SQL statements for the underlying database system.
准备语句相比普通查询来说要快很多,当然跟使用的数据库有关系。
Prepared statements can be significantly faster than regular queries depending on the database being used.
在多个查询语句的执行过程中需要保持数据库连接,否则会抛出一个延迟加载异常,这将导致数据出现问题。
Database connection needs to be maintained for the duration of the multiple query cycle else a lazy loading exception is thrown, resulting in inadequate use of resources.
如果您的JDBC程序使用已经准备好的语句和参数标志,并且如果在数据库语句缓存中找到了它们的话,查询过程将处理地更快。
If your JDBC program USES prepared statements and parameter markers, queries are processed faster if they are found in the database statement cache.
可以在标签内将SQL(结构化查询语言)语句传递给数据库。
Inside a tag, you pass SQL (Structured Query Language) statements to your database.
MongoDB 优于其他文档数据库的一个特性是它很容易将SQL语句转换成 MongoDB查询函数调用。
One feature that differentiates MongoDB from other document databases is that it is very straightforward to translate SQL statements into MongoDB query function calls.
在查询运行时,在另一个会话中(这里是 SESSION2)连接数据库,然后查找与该语句关联的 executable_id。
While the query is running, from another session (SESSION2 in this example) connect to the database and find out the executable-id associated to the statement. We can see it is
这意味着Clustrix群集数据库应该能够以最大的并行性执行查询语句,许多同步查询具有最大的并发性。
That means the Clustrix Clustered Database is supposed to execute the query with maximum parallelism and many simultaneous queries with maximum concurrency.
指定了别名,就可以在目标数据库中用sql语句查询远程表,就像查询任何本地表一样。
Specifying the nickname, the remote table can be queried in SQL statements on the target database like any other local table.
这个集合解析器查询用户提供的已命名查询,附加位置参数,并针对数据库执行JDBC语句。
This collection resolver looks up the named query as provided by the user, attaches the position parameters, and executes JDBC statements against the database.
该特性扩展了IDS的功能,使其可以不去修改查询语句,以保证与其他符合SQL标准数据库服务器的互操作性。
This feature expands the capability of IDS to run without modification queries that are interoperable on other database servers that support industry-standard SQL syntax.
下文将介绍SELECT语句的基础知识,它允许您为启用数据库的应用程序构建功能强大的查询。
The rest of this article covers the basics of the SELECT statement, which let you build powerful queries for your database-enabled applications.
现在,当同一个查询运行时,生成的原生sQL是单个选择语句,在语句在数据库层联接来自不同目录的两个表,如图10所示。
Now, when the same query is run, the native SQL that is generated is a single select statement joining the two tables from the different catalogs at the database tier as shown in Illustration 10.
如果您还没有找到陷阱,请注意其中的查询看起来有点象从数据库读取数据的模型逻辑,而out. println语句中的信息看起来象是HTML。
If you haven't spotted the trap, notice that the query looks suspiciously like model logic reading from a database, and the information in the out.println statements looks like HTML.
当创建这个查询时,SQL语句并没有被发送到数据库中,只有当你在代码中对这个IQueryable对象进行Iterate操作时,这个SQL语句才会被创建并执行,这个概念就是延迟执行。
At the moment the query is created, no SQL statement is issued to the database. The SQL statement is created and executed when your code iterates the IQueryable object.
本系列教程为您讲解SQL的一些基础和高级话题以及XQuery的基础知识,并展示如何使用SQL查询或XQuery语句将常被问起的业务问题表达为数据库查询。
This tutorial series teaches basic to advanced SQL and basic XQuery topics and shows how to express commonly asked business questions as database queries by using SQL queries or XQueries.
查询工具是数据库管理器的一个辅助工具,它作用就是定义一条符合SQL标准的查询语句。
The query tool is an assistant tool of the database manager, and it can define a query sentence accord with SQL standard.
本文主要探讨了数据库查询优化的策略,其中包括基于索引的优化、基于SQL语句的优化和一些其它优化方法。
This paper mainly discussed the database inquiry optimization, includes the optimization based on index, optimization based on SQL sentence and a few other optimization methods.
本文增强了对查询语句中的数据库隐含知识的处理能力。
This paper proposes how to improve the ability of processing the implicit knowledge of the database of the query sentences.
对数据库受限汉语自然语言查询语句进行分词处理。
This paper describes the word segmentation of database natural language query based on restricted Chinese.
说明:非常简单的数据库代码并附上报告,实现的功能是用SQL语句完成整个查询操作。
Very simple database code along with the report, the function is to use SQL statements to complete the query operations.
说明:非常简单的数据库代码并附上报告,实现的功能是用SQL语句完成整个查询操作。
Very simple database code along with the report, the function is to use SQL statements to complete the query operations.
应用推荐