SELECT 命令可用于从 Mysql 表中获取一列或多列作为输出。下面给出了一个示例来获取一列或多列mysql> Select * from Student; +------+---------+---------+---
SELECT 命令可用于从 Mysql 表中获取一列或多列作为输出。下面给出了一个
示例来获取一列或多列
mysql> Select * from Student;
+------+---------+---------+-----------+
| Id | Name | Address | Subject |
+------+---------+---------+-----------+
| 1 | Gaurav | Delhi | Computers |
| 2 | Aarav | Mumbai | History |
| 15 | Harshit | Delhi | Commerce |
| 17 | Raman | Shimla | Computers |
+------+---------+---------+-----------+
4 rows in set (0.01 sec)
mysql> Select Name,Subject from Student;
+---------+-----------+
| Name | Subject |
+---------+-----------+
| Gaurav | Computers |
| Aarav | History |
| Harshit | Commerce |
| Raman | Computers |
+---------+-----------+
4 rows in set (0.00 sec)
上面的查询从“学生”表中获取两列“姓名”和“主题”。
mysql> Select Address from Student;
+---------+
| Address |
+---------+
| Delhi |
| Mumbai |
| Delhi |
| Shimla |
+---------+
4 rows in set (0.00 sec)
上面的查询仅从“学生”表中获取一列“地址”。
--结束END--
本文标题: 我们如何从 MySQL 表中获取一列或多列作为输出?
本文链接: https://www.lsjlt.com/news/437246.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-16
2024-05-16
2024-05-16
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0