Listing 3: SQL that created the users table.
清单3:创建用户表的sql。
Run rake db: migrate to create the USERS table.
运行rakedb:migrate以创建users表。
So, let's add a USERS table to serve this purpose.
为此我们添加一个users表。
Run rake db: migrate to add email column to USERS table.
运行rakedb:migrate,将email列添加到USERS表中。
This USES data from the Users table in the database.
它使用来自数据库中users表中的数据。
The work items table is now nested within the users table.
现在工作项表格在用户表中的位置已经固定了。
Two tables are created — a USERS table and a CONTACTS table.
创建了两个表——一个是users表,另外一个是contacts表。
It shows a select of the USERS table with one parameter, apacheu.
它显示了使用一个参数apacheu来选择users表。
Run rake db: migrate to add these new columns to the USERS table.
运行rakedb:migrate,在USERS表中添加这些新列。
On the next screen, click Users and the > button to select the users table.
在下一屏中,单击Users和 >按钮以选择用户表。
A user enters a user name and password that matches a record in the Users table.
用户输入与users表中记录匹配的用户名和密码。
A SQL query to retrieve a user from a users table might look like Listing 1.
从users表中检索用户的SQL查询可能类似于清单1。
You can put that field into another table to keep updates to your users table to a minimum.
这种情况就可以将该字段将到另外一张表中,从而将用户表的更新减少到最小。
Inside the users table, I'm storing the username, password and the first name of all the users.
在用户表,我存储的用户名,密码,所有用户的名字。
The belongs_to expresses the one-to-one foreign key relationship between the DOCUMENTS and USERS table.
belongs_to表达了DOCUMENTS与USERS表之间一对一的外键关系。
Entering this query reveals the user names and passwords found in the Users table, as shown in Figure 3.
输入此查询可披露在Users表中找到的用户名和密码,如图3所示。
If you have modified the Users table schema, be sure to make the matching changes to the Insert statement.
如果已经修改了users表的模式,那么一定要对insert语句进行相应的修改。
So, assuming there's at least one row in the Users table, this SQL will always return a nonzero count of records.
因此,假定users表中至少存在一行,此SQL将始终返回非零的记录计数。
The get_user function connects to the database that contains the users table and retrieves the ID for a given user.
get_user函数连接到包含用户表的数据库并检索给定用户的ID。
Recall that the session ID belongs to table sessions, but the desired information is stored in the users table.
回忆一下,会话id属于表sessions,但是想要的信息存储在users表中。
The SQL injection attack shown in Figure 3 resulted in the display of user names and passwords from the Users table.
图3所示的SQLInjection攻击导致显示users表中的用户名和密码。
In a production application, you likely have a users table, and the games table includes the user IDs of both players.
在生产应用程序中,您可能有一个用户表,而games表正是包含了两位玩家的用户ID。
I said in Part 1 that I was going to have a users table in SimpleDB, but it complicated the site too much, so I dropped it.
我在功能丰富的Perl: perl和amazon云,第1部分说过,我将在SimpleDB中使用一个用户表,但是它会使站点变得非常复杂,因此放弃了这个想法。
Listing 3 is a nice example I created to search for people in a users table, based on a location and date-of-birth variables.
清单3是一个很好的示例,创建它是为了根据位置和出生日期变量来搜索用户表中的用户。
Before storing a user's record into the users table, for example, it's likely that a PHP script USES crypt to encrypt the password.
例如,在将用户记录存储到用户表之前,php脚本可以使用crypt对密码加密。
A table, often called the users table, that contains at least two columns, one for the logon identifier and one for the password.
一个通常被称作用户(users)表的表,至少包含两列,一列为登录标识符,一列为口令。
Use the SQL code shown in Listing 1 to create the first table, called users. (If you already have a users table in place, please ignore this.)
使用清单1中的SQL代码创建第一个表,即users 表(如果已经有一个 users 表,则可以跳过这一步)。
In the database design above, according to the needs, I design role table, users table, document table, department table, message table, employ table.
在数据库的设计上面,根据系统的需要,设计了角色表、用户表、部门表、文档表、员工表、短信表。
In the database design above, according to the needs, I design role table, users table, document table, department table, message table, employ table.
在数据库的设计上面,根据系统的需要,设计了角色表、用户表、部门表、文档表、员工表、短信表。
应用推荐