Hi all,
I am using PHP and what i know is that without select statement in the query
we can not fetch anything . I mean if we do not give select what will be the
field headers.
Pl. clarify how can we fetch rfom this query.
UPDATE `table_name` SET `field`=`field`+1;
Also can we lock and unlock tabl
1. A single query that fetvhes a value, increases it and save it :
UPDATE `table_name` SET `field`=`field`+1;
2. You can lock tables, make updates an then unlock them, the
other processes will wait the table to be unlocked before running
their queries :
LOCK TABLES `table_name` WRITE;
{SQL st
Dear Friends,
I run several processes and they need to query the mysql 5.0.8 database
simultaneously .I have a config table which have the record id. I need to
fetch that and increment that .What I feel that the same record id is
fetched by different simultaneosly before i update .Can anyone help m