Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ahsan Rana
  Where is Ahsan Rana?
 Lahore
 Pakistan
 Ahsan Rana
 To: llyrad atsituab
  Where is llyrad atsituab?
 Tacloban City
 Philippines
 llyrad atsituab
 Tags
Subject: RE: Table Lock in MySql
Thread ID: 373413 Message ID: 373557 # Views: 34 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Saturday, March 23, 2013 10:36:07 AM         
   


> >
> >
> > How, Is the following command line correct..?
> >
> > = sqlexec(mConn,"Lock Tables 'abc'")
> >
> > Rgds:
> > Ahsan Rana
>
> SQL Data = [LOCK TABLES abc write]
>
> SQLExec(mConn,SQLData)
>
> to unlock the tables;
>
> SQL Data = [UNLOCK TABLES]
>
> SQLExec(mConn,SQLData)
>
> Do you have a MySQL Workbench,HeidiSQL,Phpmyadmin,or Navicat?? Try to download some database management tool so that you will be able to test all your SQL query..
>
> You can read this..
> http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html
> http://www.databasejournal.com/features/mysql/the-pros-and-cons-of-mysql-table-locking.html
>
> Regards:
> carbcoder_02

Thnx carbcoder_02, Key word "Write" means table locked only for writing not for reading..?

Rgds:
Ahsan Rana

ENTIRE THREAD

Table Lock in MySql Posted by Ahsan Rana @ 3/22/2013 3:32:58 AM
RE: Table Lock in MySql Posted by Tom Saddul @ 3/22/2013 5:36:17 AM
RE: Table Lock in MySql Posted by Ahsan Rana @ 3/22/2013 11:36:41 AM
RE: Table Lock in MySql Posted by llyrad atsituab @ 3/23/2013 2:50:17 AM
RE: Table Lock in MySql Posted by Ahsan Rana @ 3/23/2013 10:36:07 AM
RE: Table Lock in MySql Posted by Tom Saddul @ 3/23/2013 10:47:07 AM
RE: Table Lock in MySql Posted by llyrad atsituab @ 3/23/2013 2:43:08 AM
RE: Table Lock in MySql Posted by Tom Saddul @ 3/23/2013 5:05:02 AM
RE: Table Lock in MySql Posted by llyrad atsituab @ 3/22/2013 6:17:50 AM
RE: Table Lock in MySql Posted by tushar @ 3/23/2013 10:56:27 AM
RE: Table Lock in MySql Posted by Ahsan Rana @ 3/23/2013 11:23:28 AM
RE: Table Lock in MySql Posted by tushar @ 3/23/2013 11:54:05 AM
RE: Table Lock in MySql Posted by Ahsan Rana @ 3/23/2013 12:39:57 PM
RE: Table Lock in MySql Posted by tushar @ 3/23/2013 1:14:54 PM
RE: Table Lock in MySql Posted by Ahsan Rana @ 3/23/2013 4:44:38 PM
RE: Table Lock in MySql Posted by tushar @ 3/23/2013 5:19:25 PM
RE: Table Lock in MySql Posted by Ahsan Rana @ 3/23/2013 6:08:36 PM
RE: Table Lock in MySql Posted by Om Rajan @ 3/23/2013 9:31:19 PM
RE: Table Lock in MySql Posted by Tom Saddul @ 3/23/2013 12:12:06 PM
RE: Table Lock in MySql Posted by Ahsan Rana @ 3/23/2013 12:41:11 PM