I had a requirement to display serial numbers in Zend grids. So, in order to fulfill this, I had a worse idea of using a count variable and displaying the same as serial number but, Zend grids will not allow such worst ideas to implement.
So had explored for a solution to generate serial numbers or [...]

Locking: Locking is the mechanism which locks the tables, records, and pages based upon the requirement.
we have different types of locks are there in MySql.

Read/Write Locks.
Table Locks.
Page Locks.
Record Locks.

Let us have example on the single record lock by using select for update statement.
suppose we are using
select item_id from the item_table where item_id=’100′ for update.
This 100 [...]

Transactions are very important topic in the Mysql. let us suppose we are working with the Mysql database that is auto commit mode is true. but in all scenarios auto commit mode true will be not safe in that situvations we can turn off MySql database into different modes either Auto commit mode is true [...]

Export
steps:
1) mysqldump -u web_user -p databasename > sqlfilename
2) Prompts you to enter Password:
3)Enter the password then the database will be backup on given sqlfile
Import
mysqldump -u web_user -p database_name < sqlfilename

A transaction isolation level sets the default transactional behavior. As the name suggests, the setting determines how isolated each transaction is, or what kind of locks are associated with queries inside a transaction. The four levels, in ascending order of strictness, are:
 

READ UNCOMMITTED: Barely transactional, this setting allows for so-called ‘dirty reads’, where queries inside one transaction [...]

 
I would like to share with you about the problem we have faced in maintaining concurrency in stock inventory in HMS and the various approaches that we have followed to resolve the problem. As most of us are MySql users and the solutions would really help you in your respective projects.
 
Problem Scenario: ”We ran into a [...]

Hi all,
There is a useful link for PHP Mysql tutorials.This teaches us about using PHP and mysql in a better way.
I’m sure that by the end of this tutorial you will have enough knowledge to build your own database driven website using PHP & MySQL.
you can find this at  http://www.php-mysql-tutorial.com/