select * from mys where id=2;

+----+----------+----------+------+
| id | name     | password | age  |
+----+----------+----------+------+
|  2 | zhangsan | qwer     |   43 |
+----+----------+----------+------+
注意:查出来是两行,不是一行。

原文地址:https://www.cnblogs.com/xilin/p/2609028.html