Re: Bad field type translation

2003-02-21 Thread gerald_clark
Since you are comparing a string to a number, it probably can not use the index. Perhaps you should be more careful with your queries. Gatica, Mario Alberto wrote: I found the following error with mysql server version 3.23.52. mysql select snb,id_servicio from Abonados_Servicios where

Bad field type translation

2003-02-20 Thread Gatica, Mario Alberto
I found the following error with mysql server version 3.23.52. mysql select snb,id_servicio from Abonados_Servicios where snb=1144293549; 9 rows in set (0.01 sec) mysql select snb,id_servicio from Abonados_Servicios where snb=1144293549; 9 rows in set (45.61 sec) mysql describe