Hi,
What will happen is that the rdbms will lock the row for you, updates it and
unlock it.
This is transparent for the user.
there will be a wait (not a problem) if another user want to update the same
row. When the first transaction is committed, the second can hold a lock for
update.
There is
Hi!
If there is no any lock at all while one update a row, what it is going to
happen to my SQL database? In which cases, it might cause problems? Anyone know?
Thanks
__
Switch to Netscape Internet Service.
As low as $9.95 a mont
On 26 Aug 2001 13:55:40 -0700, Jeremy Zawodny wrote:
> On Sun, Aug 26, 2001 at 11:52:15PM +0200, Boaz Yahav wrote:
> > Does mysql have something like NO LOCK?
> >
> > SELECT * FROM mytable WHERE myfield='xyz' NO LOCK
>
> By default, no. But if you use Inn
On Sun, Aug 26, 2001 at 11:52:15PM +0200, Boaz Yahav wrote:
> Does mysql have something like NO LOCK?
>
> SELECT * FROM mytable WHERE myfield='xyz' NO LOCK
By default, no. But if you use InnoDB tables in MySQL, you'll get
non-locking SELECTS, which is probably what you&
Does mysql have something like NO LOCK?
SELECT * FROM mytable WHERE myfield='xyz' NO LOCK
berber
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/