Listing 3: SQL that created the users table.
清单3：创建用户表的sql。
Run rake db: migrate to create the USERS table.
运行rakedb：migrate以创建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表中的数据。
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表中添加这些新列。
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 test case above, featuring an authenticated user, there is a need to populate the USERS table with a valid entry to compute the encrypted password.
在上面的测试用例中，提供一个已经通过身份验证的用户，需要用有效的数据填充users表，以便计算加密的密码。
Without knowing unique attributes of the changed users, it is impossible to construct SQL query statement that retrieve only the changed data from the users table.
在不知道已改变用户的唯一属性的情况下，构造一个SQL声明去users表中重新获取已经改变的数据是可能的。
The USERS table stores the user ID (unique name), the password (MD5 hash), the password expiration date, whether the account is locked, and the number of failed login attempts.
tusers表存储用户ID(唯一的名称)、密码、(MD 5散列值)、密码过期日期、帐户是否已被锁定以及失败登录次数。
The USERS table stores the user ID (unique name), the password (MD5 hash), the password expiration date, whether the account is locked, and the number of failed login attempts.
tusers表存储用户ID(唯一的名称)、密码、(MD 5散列值)、密码过期日期、帐户是否已被锁定以及失败登录次数。
应用推荐