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


> >
> > Yes. There is LOCK TABLES [tablename] command.
> > To unlock, execute UNLOCK TABLES
>
>
> 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

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