re: using explicit locking

2002-11-20 Thread Egor Egorov
Stephen, Wednesday, November 20, 2002, 5:48:35 AM, you wrote: SA> I've managed to build my first web database using MySQL and accessing SA> it with Python CGI scripts. I only have two tables going, and not SA> many columns per table, but I'm suspecting that there will be many SA> calls to INSERT,

Re: using explicit locking

2002-11-19 Thread vinita vigine Murugiah
HI I have a similar question. I'm using InnoDb table type (ver 3.23.53), according to the web side, it does a row level locking. Does this mean that I don't need to do any table locking during the Update/Delete/Insert queries?? How do I test it that It really doing the locking (other than ta

using explicit locking

2002-11-19 Thread Stephen Aichele
Hello. MySQL newbie here. I've managed to build my first web database using MySQL and accessing it with Python CGI scripts. I only have two tables going, and not many columns per table, but I'm suspecting that there will be many calls to INSERT, UPDATE, and SELECT. So my question is this: do