Hi William,
William Newton wrote:
Hello List,
I have this table that has a single row in it:
CREATE TABLE `quicktable` (
`x` int(11) NOT NULL auto_increment,
`quick_id` int(11) NOT NULL default '0',
PRIMARY KEY (`x`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
select * from
Hello List,
I have this table that has a single row in it:
CREATE TABLE `quicktable` (
`x` int(11) NOT NULL auto_increment,
`quick_id` int(11) NOT NULL default '0',
PRIMARY KEY (`x`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
select * from quicktable;
+---+--+
| x | q
On Mon, 02 Apr 2001, Richard Ellerbrock wrote:
> From the manual:
>
> If you are using FOR UPDATE on a table handler with page/row locks, the examined
>rows will be write locked.
>
> I agree that this does not tell me much. When are the rows unlocked?
>
educated guess..
001/04/02 03:56:33 >>>
I am, at this moment, installing MySQL version
3.23.36. I noted that the "SELECT...FOR UPDATE"
feature has been added. What does this do and how is
it used? The online manual simply mentions that it
exists; but doesn't explain what it i
I am, at this moment, installing MySQL version
3.23.36. I noted that the "SELECT...FOR UPDATE"
feature has been added. What does this do and how is
it used? The online manual simply mentions that it
exists; but doesn't explain what it is or how to use
it.
Thanks
