让我们来看一个简单的程序,它能创建一个数据库表并填入数据值。
Let's take a look at a simple program that will create a database table and populate the table with data values.
在德比郡,有一种方法来创建一个数据库表,列,缺省为utc时间戳?
In Derby, is there a way to create a database table that has a column that defaults to the UTC timestamp?
在SQLite命令行提示栏,输入清单3中的SQL命令,为应用程序变量创建一个数据库表。
At the SQLite command line prompt, enter the SQL commands shown in Listing 3 to create a database table for the application variables.
通过这种新的声明样式,SQLAlchemy能够在一步中创建一个数据库表、创建一个类以及类与表之间的映射。
With this new declarative style, SQLAlchemy is able to create a table in a database, create a class, and the mapping between the class and the table in one spot.
您可以自由创建一个或多个数据库来承载包含这些表的多种模式。
You have the freedom to create one or more databases to host the various schemas that contain the tables.
可以用一个php脚本创建这个数据库表。
对于有些人而言,为每个数据库表创建一个DAO也许看上去是非常简单的方法。
For some people, creating a DAO for each database table may seem to be a very straightforward approach.
一个数据库选项,用来指定日期维度表在初次启动被创建时预填充的天数(从当前日期开始)。
A database option that specifies the number of days (starting from the current date) to pre-populate in the date dimension table when it creates it on first startup.
注意:您也可以选择创建一个数据库触发器来捕捉表上的每个INSERT操作,并告诉它在执行INSERT之前使用XMLVALIDATE函数验证XML数据。
Note: Alternatively you can create a database trigger to capture every INSERT on your table and tell it to validate the data as XML using the XMLVALIDATE function before performing the INSERT.
此外,在DB 2中创建复制之前,您会希望保证每一个数据库表都具有一个主键或惟一索引。
Also, before setting up replication in DB2, you will want to ensure that every database table has a primary key or unique index.
请使用DB 2命令行处理器为上面的表创建一个数据库。
Go ahead and use the DB2 Command Line Processor to create a database for the table above.
首先,必须创建一个关联规则模型,该模型被存储为PMML,从中可以提取这些规则并将其放入一个数据库表以供日后的Cognos访问。
First, you must create an association rule model which is stored as PMML from which you can extract the rules into a database table for later Cognos access.
通过SQL复制,您可以创建一个配置,其中指定了您希望复制的每一个数据库表。
With SQL replication, you create a configuration that specifies each table in the database that you want to replicate.
为了在不同缓冲池中隔离对象,您可以在同一个数据库中创建一个以上的表空间,并给每一个表空间关联不同的缓冲池。
To isolate objects in different buffer pools, you can create more than one table space in the same database, and associate each table space with separate buffer pools.
在为每个客户添加数据库实例时,或者在每个表中创建一个数据列以验证客户是否访问合适的数据时,这种设计会大大增加表的数量。
This design increases the number of tables significantly over adding a database instance per customer or creating a column in each table to validate whether the customer is accessing the proper data.
一旦完成安装,您至少还需要创建一个数据库和一个表,以便在它们之间建立连接,并测试是否可以访问所创建表中的数据。
Once installed, you need to create at least one database and one table in order to create a connection and test to see if you can access data in the created table.
一个数据库选项,用来决定此应用程序是否应在时间维度表首次启动被创建时完全填充此表。
A database option that determines if the application should fully populate the time dimension table when the table is created on first startup.
在创建一个数据库时,也会顺带创建一组编目表和视图。
A set of catalog tables and views is created whenever a database is created.
在可以执行数据库查询之前,必需创建一个数据库,其中包含用相关数据填充的多个表。
But before you can perform a database query, you must create a database that contains several tables populated with relevant data.
然而,如果这里存在一个针对于受支持的不同数据库以前的一个自上而下的映射,这时创建的表和数据源都将在这个数据库中。
However, if there was a previous top-down mapping against a different supported database, then any tables and data source created will be in that database.
重要的是,要注意当每一个数据库表空间创建时,文件系统缓存已经通过指定NOFILESYSTEM cache子句并被禁用。
It is important to note that file system caching was disabled by specifying the no file system CACHE clause when each table space in the database was created.
目录表空间:每个数据库只有一个目录表空间,它是在发出CREATEDATABASE命令时创建的。
Catalog table space: There is only one catalog table space per database, and it is created when the create database command is issued.
因为在同一个数据库模式中不可能有两个同名的表,所以临时用SALES _ TMP这个名称创建新的表。
Because it is not possible to have two tables with identical names in the same schema, the new table is temporarily created with the name SALES_TMP.
使用别名在另一个数据库中创建表拷贝。
Creating a table copy in another database by using a nickname.
使用下面的MySQL命令创建数据库,并对其授权,然后向这个数据库中添加一个表。
Use the following MySQL commands to create the database, grant permissions on it, and add a table to it.
第 1 步:我们假设已经用默认表空间创建了一个数据库,同时创建下面的事实表和维度表。
STEP A: We assume you have created a database with the default table spaces. Create the fact and dimension tables as follows.
随后,它将为这个数据库创建一个模型,该模型稍后用来在MySQL中生成一个新的数据库,该数据库在表中新增了TenantID字段。
It then creates a model of that database which is subsequently used to generate a new database in MySQL that has the additional TenantID field in the tables.
在我们的示例中,我们将在一个数据库中的地区性account表和另一个数据库中的sales表之间创建一个关系。
In the example we are using, a relationship can be created between the regional Account table from one database to the Sales table in the other database.
新建一个数据库时,会在默认情况下创建以下3个表空间。
When a database is first created, three table Spaces are created by default. These table Spaces are as follows.
所以,让我们在MySQL数据库中创建一个数据库,并在此数据库中创建第一张表。
So let's create a database in MySQL and craft a first table within this database.
应用推荐