[thelist] weird MySQL insert problem

[Shashank Tripathi]

Is there any particular reason why you are inserting it as a string, but
selecting it as a number? Try:

    SELECT * FROM candidate_information WHERE can_id = '999';

Notice the single quotes around 999 even in the select.

Hope this helps,
Shanx




> mysql> INSERT INTO candidate_information (can_id) VALUES ('999');
> Query OK, 1 row affected (0.00 sec)
>
> mysql> SELECT * FROM candidate_information WHERE can_id = 999;
> Empty set (0.06 sec)
> ******