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
