这张表一共有几行
学号
姓名
班级
1001
小雨
三班
1002
阿泰
五班
1003
小满
三班
把整张学习记录表取出来看看:
这张表一共有几行记录?(不算最上面那一行标题)
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>
全部评论