Hi everybody
I sent a couple of mail recently, asking some help for some strange
behaviour with select and updates.
I hope many of you have read it...the problem was that making a
SELECT something FROM table WHERE 'Where_Clause'
gave some results, >0.
the query:
UPDATE table SET something WHE
Hi everybody
I got weird behaviour from Mysql while doing some updates.
Before doing the update I did a count, like this:
select count(*) from Yellow WHERE MATCH(street_add) AGAINST('+GUIDO
+MIGLIOLI' IN BOOLEAN MODE) AND street_short = '';
and the result was 50 rows in set.
But when I ran t
Hi everybody.
I got a really weird behaviour from Mysql, while doing some select and
update queries.
I made a select, something like:
SELECT Something FROM WHERE
and the result was not empty. But when I tried to make an update:
UPDATE..WHERE , with THE SAME WHERE clause, result wa