示例来获取一列或多列
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)
上面的查询仅从“学生”表中获取一列“地址”。
以上就是我们如何从 mysql 表中获取一列或多列作为输出？的详细内容。