mysql select from user_求助MySQL中有关查询的问题select tuser from user where tuser='test1';...

mysql>select*fromuser;+----+--------+----------------------------------+------------+------------+|id|tuser|pw|postscript|permission|+----+--------+----------------------...

mysql> select *from user;

+----+--------+----------------------------------+------------+------------+

| id | tuser | pw | postscript | permission |

+----+--------+----------------------------------+------------+------------+

| 1 | test1 | fcea920f7412b5da7be0cf42b8c93759 | | guest |

+----+--------+----------------------------------+------------+------------+

1 row in set (0.00 sec)

mysql> select tuser from user where tuser='test1';

Empty set (0.00 sec)

mysql> select * from user where tuser='test1';

Empty set (0.00 sec)

mysql> select tuser from user where permission='guest';

+--------+

| tuser |

+--------+

| test1 |

+--------+

1 row in set (0.00 sec)

为什么select tuser from user where tuser='test1';查询不到数据？

展开