About NoWait of MySql

Hi, MySQL Developers

I'm a beginner of MySQL, and so I'm in a trobble. in MySQL 5.0.45
and acctually, I'm trying to migration my application
from Oracle to MySQL
I'd like to use nowait option (of Oracle) in MySQL when locking one record.
but I could not find nowait oitpin in MySQL.

so I have some question to solve.

1. Does MySQL have lock option like Oracle's nowait or alternative way.
acctually I'd not like to use innodb_lock_wait_timeout configuration.
for some reasons...
2. Do you hava a plan to implement nowait option to the latest MySQL
(and the what version of MySQL will you plan to implement)

I'm sorry for my poor English, and I'd appriciate if you would answer my
questions.

thanks in advance, Yusuke.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: About NoWait of MySql

門田 祐輔 indexweb.co.jp> writes:


> 1. Does MySQL have lock option like Oracle's nowait or alternative way.
> acctually I'd not like to use innodb_lock_wait_timeout configuration.
> for some reasons...

I think that non-blocking queries are not supported by mysql driver natively.





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org