mysql - strange results

mysql - strange results

Post by stam.. » Wed, 12 Apr 2000 04:00:00



I hope that I'm missing something here:  Any help?

Here's the table:

mysql> desc message;
+------------+-----------------------------------------------+------+-----+---------+----------------+

| Field      | Type                                          | Null |
Key | Default | Extra          |
+------------+-----------------------------------------------+------+-----+---------+----------------+

| id         | int(11)                                       |      |
PRI | 0       | auto_increment |
| size       | mediumint(9)                                  |
|     | 0       |                |
| time       | varchar(26)                                   |
|     |         |                |
| longstatus | varchar(90)                                   |
|     |         |                |
| fromid     | int(11)                                       |      |
MUL | 0       |                |
| toid       | int(11)                                       |      |
MUL | 0       |                |
| status     | enum('success','failure','deferral','bounce') |      |
MUL | success |                |
+------------+-----------------------------------------------+------+-----+---------+----------------+

7 rows in set (0.00 sec)

The first row is the one I can't figure out. Any ideas?

mysql> select fromid, toid from message where toid=419493;
+--------+---------+
| fromid | toid    |
+--------+---------+
|    252 | 1485721 |
|    226 |  419493 |
|    176 |  419493 |
|    172 |  419493 |
|    195 |  419493 |
|    184 |  419493 |
|    214 |  419493 |
|    215 |  419493 |
|    222 |  419493 |
|    226 |  419493 |
|    173 |  419493 |
|    240 |  419493 |
|    252 |  419493 |
|    226 |  419493 |
|    263 |  419493 |
+--------+---------+
15 rows in set (0.03 sec)

-thanks,
Levi

 
 
 

mysql - strange results

Post by Richard Won » Wed, 12 Apr 2000 04:00:00


is there anything to do with "formid" ?
the number 252 appear twice ?

it really look like a bug to me ....
what ver are u using ?


Quote:> I hope that I'm missing something here:  Any help?

> Here's the table:

> mysql> desc message;

+------------+-----------------------------------------------+------+-----+-
--------+----------------+
Quote:

> | Field      | Type                                          | Null |
> Key | Default | Extra          |

+------------+-----------------------------------------------+------+-----+-
--------+----------------+
Quote:

> | id         | int(11)                                       |      |
> PRI | 0       | auto_increment |
> | size       | mediumint(9)                                  |
> |     | 0       |                |
> | time       | varchar(26)                                   |
> |     |         |                |
> | longstatus | varchar(90)                                   |
> |     |         |                |
> | fromid     | int(11)                                       |      |
> MUL | 0       |                |
> | toid       | int(11)                                       |      |
> MUL | 0       |                |
> | status     | enum('success','failure','deferral','bounce') |      |
> MUL | success |                |

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

- Show quoted text -

Quote:

> 7 rows in set (0.00 sec)

> The first row is the one I can't figure out. Any ideas?

> mysql> select fromid, toid from message where toid=419493;
> +--------+---------+
> | fromid | toid    |
> +--------+---------+
> |    252 | 1485721 |
> |    226 |  419493 |
> |    176 |  419493 |
> |    172 |  419493 |
> |    195 |  419493 |
> |    184 |  419493 |
> |    214 |  419493 |
> |    215 |  419493 |
> |    222 |  419493 |
> |    226 |  419493 |
> |    173 |  419493 |
> |    240 |  419493 |
> |    252 |  419493 |
> |    226 |  419493 |
> |    263 |  419493 |
> +--------+---------+
> 15 rows in set (0.03 sec)

> -thanks,
> Levi