I don't know how else to explain the problem I'm having.
I'm inserting a name into a database and when I try to retrieve it back out, it returns no values.
Look:
mysql> SELECT name FROM qperson; +--------------+
| name |
+--------------+
|
Janine |
|
Ben |
+--------------+
2 rows in set (0.00 sec)
Now, trying to retrieve it:
mysql> SELECT name FROM qperson WHERE name = 'Ben';
Empty set (0.00 sec)
When in fact it's there.
Now...here's the thing. I'm mirroring this database at home as well as on my school account. Here's the data at home:
mysql> SELECT name FROM qperson;
+-------------------+
| name |
+-------------------+
| Janine |
| Mike |
| Ben |
| Steven |
| Jeff |
+-------------------+
5 rows in set (0.01 sec)
And the retrieval works:
mysql> SELECT name FROM qperson WHERE name = 'Ben';
+---------+
| name |
+---------+
| Ben |
+---------+
1 row in set (0.00 sec)
I don't know why the first example isn't working? i notice that the display table is a bit goofed up, but don't know if this means anything.
Could extra characters be added to the data? Anyone have any ideas why this is happening?
