< Browse > Home / Archive by category 'Mysql'

| Mobile | RSS

sudhakar.dasari

Generating Serial No./Row No.

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 [...]

[ More ] September 11th, 2009 | No Comments | Posted in Mysql |
bhagat.illalova@scubetech.in

Locking records and Dead lock detection and solution in Mysql

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 [...]

[ More ] July 16th, 2009 | 1 Comment | Posted in Mysql, Uncategorized |
bhagat.illalova@scubetech.in

Transactions in MySql used in Vb.net

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 [...]

[ More ] July 16th, 2009 | No Comments | Posted in Mysql, VB.NET |
naveen.malla

Export and Import MYSQL Linux commands

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

[ More ] May 14th, 2009 | No Comments | Posted in Mysql, Php |
lalitha.chekuri

Transaction Isolation Levels in Mysql

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 [...]

[ More ] May 14th, 2009 | 1 Comment | Posted in Mysql |
lalitha.chekuri

Concurrency and Transactions in MySql

 
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 [...]

[ More ] May 14th, 2009 | No Comments | Posted in Mysql |
admin

PHP Mysql Tutorial

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/

[ More ] November 15th, 2008 | 1 Comment | Posted in Mysql, Php |