让我们首先创建一个表-create table DemoTable717 (
UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
UserPassword int
);
使用插入命令在表中插入一些记录-insert into DemoTable717(UserPassword) values(1454343);
insert into DemoTable717(UserPassword) values(674654);
insert into DemoTable717(UserPassword) values(989883);
insert into DemoTable717(UserPassword) values(909983);
使用select语句显示表中的所有记录-select *from DemoTable717;
这将产生以下输出-+--------+--------------+
| UserId | UserPassword |
+--------+--------------+
| 1 | 1454343 |
| 2 | 674654 |
| 3 | 989883 |
| 4 | 909983 |
+--------+--------------+
4 rows in set (0.00 sec)
以下是创建随机4位数字并为“ UserPassword”列设置的查询-update DemoTable717
SET UserPassword=(select floor(0+ RAND() * 10000));
Rows matched: 4 Changed: 4 Warnings: 0
让我们再次检查表记录-select *from DemoTable717;
这将产生以下输出-+--------+--------------+
| UserId | UserPassword |
+--------+--------------+
| 1 | 4319 |
| 2 | 3902 |
| 3 | 6553 |
| 4 | 1060 |
+--------+--------------+
4 rows in set (0.00 sec)