需求三:这个人的编号是多少

👁️ 0 人浏览 💬 0 人评论 ❤️ 添加收藏

需求:"xiaogang 这个人的用户编号是多少?"

从整张表里找出来:

mysql> SELECT * FROM learning_record;
+----+---------+-----------+-------------+----------+------------+
| id | user_id | user_name | path_code   | progress | updated    |
+----+---------+-----------+-------------+----------+------------+
|  1 |     101 | xiaoming  | l1_basic_01 |      100 | 2026-03-01 |
|  2 |     101 | xiaoming  | l1_lang_01  |       60 | 2026-03-04 |
|  3 |     101 | xiaoming  | l1_os_01    |       20 | 2026-03-05 |
|  4 |     102 | xiaohong  | l1_basic_01 |      100 | 2026-03-02 |
|  5 |     102 | xiaohong  | l1_basic_02 |       45 | 2026-03-05 |
|  6 |     103 | xiaogang  | l1_basic_01 |       30 | 2026-03-03 |
|  7 |     104 | zhangsan  | l1_basic_01 |      100 | 2026-03-01 |
|  8 |     104 | zhangsan  | l1_lang_01  |      100 | 2026-03-03 |
|  9 |     104 | zhangsan  | l1_db_01    |       15 | 2026-03-05 |
| 10 |     105 | lisi      | l1_basic_01 |       80 | 2026-03-04 |
+----+---------+-----------+-------------+----------+------------+
mysql>
提交你的答案
请登录后提交答案。
去登录
代码编辑器
Ctrl + Enter 运行
本次输入:
输出:

                        
👩‍🏫
AI
💬 题目评论

全部评论