English Grammar and
Examples
Idioms
Jargon
Body language
MYSQL
Example of Binlog MYSQL Statement
Example of Create Server MYSQL Statement
Example of Cursor Close MYSQL Statement
Example of Cursor Fetch MYSQL Statement
Example of Cursor Open MYSQL Statement
Example of Declare Cursor For MYSQL Statement
Example of Load XML MYSQL Statement
Example of Show Create Trigger MYSQL Statement
Example of Show Relaylog Events MYSQL Statement
Example of Truncate Table MYSQL Statement
Example of Handler MYSQL Statement
Example of Loop MYSQL Statement
Example of Resignal MYSQL Statement
Example of Return MYSQL Statement
Example of Signal MYSQL Statement
Show Function Status
Show Index
Show Master Status
Show Privileges
Show Procedure Code
Show Procedure Status
Show Privileges
Show Profile
Show Profiles
Show Slave Status
Show Status
Show Triggers
Show Variables
Show Function Code
Call
Drop Function
Insert
Install Plugin
Load data infile
Replace

Full list of MYSQL
   Business Letters   Personal Letters   Resumes   CVs and more
       Facebook Example of Lock Tables and Unlock Tables Mysql Statement LINKED IN Example of Lock Tables and Unlock Tables Mysql Statement del-icio-us Example of Lock Tables and Unlock Tables Mysql Statement

Example of Lock Tables and Unlock Tables Mysql Statement:

LOCK TABLES t1 READ;
SELECT COUNT(*) FROM t1;

LOCK TABLE t READ;
SELECT * FROM t AS myalias;
LOCK TABLES trans READ, customer WRITE;
SELECT SUM(value) FROM trans WHERE customer_id=some_id;
UPDATE customer
SET total_value=sum_from_previous_statement
WHERE customer_id=some_id;
UNLOCK TABLES;

Example of Mysql Lock Tables and Unlock Tables

LOCK TABLES
tbl_name [[AS] alias] lock_type
[, tbl_name [[AS] alias] lock_type] ...
lock_type:
READ [LOCAL]
| [LOW_PRIORITY] WRITE

UNLOCK TABLES
         


Link to this page:
* Required Fields
 Add Comment:
Name* :
Email :
Comment* :
 
Contact Us About Us Privacy Policy Disclaimer
Copyright © 2008 - 2011 ExamplesOf .com