Yes, don't lock the table. MySQL will handle the lock for you on the insert. this isn't access. its a multi-user system. with access you have to lock the table.
Curtis On Tue, 6 Aug 2002, Pradeep Dsouza wrote: > Dear list > > I have written a large application which i call Edupro which uses > PEAR and Mysql as the DB > > Everything was fine till i notied that when > i was trying to lock the tables for WRITE access It showed an > error and the table couldnt be locked > > Is there something i need to do before i lock a table on Win2k > Please help i cannot proceed without the Lock > This same code works perfectly fine on 98 > Does it have some thing to do with the NTFS file system > i feel it does please tell me how to get around this > > This iswhat i am doing LOCK tables tablename Write; > > I get an error immedieatley > Thanks in Advance > Pradeep > > > > # Pradeep Dsouza > # RH-04 E-11 Sector -09 > # CBD Navi Mumbai > # Maharashtra > # India > # > # Tel: 091 - 022 - 7573097 > # Mob: 98205 80286 > # Email : [EMAIL PROTECTED] > # http://www.naharonline.com > # Multiple platforms ... Multiple technologies ... We provide it all....... > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
