Hi all,
Can we run a query like UPDATE table_name set abc='1'; and still fetch the
value from a column from table .
I mean Can we run select And update query in one statement. If yes how.
Pl. tell me for versions 4.x and 5.x
Pl. do help me.
--
Regards
Abhishek Jain
On 4/20/06, abhishek jain
WEBBEE . BIZ wrote:
Hi all,
Can we run a query like UPDATE table_name set abc='1'; and still fetch the
value from a column from table .
I mean Can we run select And update query in one statement. If yes how.
Pl. tell me for versions 4.x and 5.x
Pl. do help me.
Hmm should work with PROCEDURE
No i do not want an autoincrement key , as i want to be only one row in the
table and it value gets incremented / updated and i to know whats its
current value.
--
Regards
Abhishek Jain
On 4/19/06, Michael Kruckenberg [EMAIL PROTECTED] wrote:
Seems like what you need is an auto-increment key.
Seems like what you need is an auto-increment key. Is that out of the
question?
On Apr 18, 2006, at 1:34 AM, abhishek jain wrote:
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
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