Category: Database

Introduction to DataBase Isolation Levels Transaction specifies an isolation level that defines the degree to which one transaction must be isolated from resource or data modifications made by other transactions. Isolation Levels are described in terms of side-effects of concurrent

Problem: How to insert csv data into mysql table with mysql query in php. What problems usually you face with this and how to resolve them. Description: I have csv file with thousands of records. I want to insert these

When you do svn update or commit in Eclipse you may face this problem- “working copy xxxxx locked” Solution: Sometimes the problem can be solved with “project cleanup” or “move the project to some other location without .project and .svn

Heroku throwing ERROR: “The datasource configuration “default” was not found in database.php” with database configuration already present for cakephp app. In one of our cakephp projects hosted on Heroku we used PostgreSql database. For configuring the database to connect to

While fetching data from database, in SQL query I had ‘order by’ clause but the results were not sorted when the data was in alphanumeric form. The reason for this is that SQL sorts character by character from left to

Let us take an example: We have table employees with following fields: id int primary key, name varchar(50), city varchar(50) We have following records in the table: (1, isha, amr); (2, Hamlet’s, ghy); (3, éhjj, amr); 2nd and 3rd records

We have two tables say table1 and table 2. In table 1, there is a field named Id and this field is set as primary key in table 1. We want to use it as foreign key in table 2.

Steps to create a connection to a local postgres database in pgAdmin ||| : 1. Make sure PostgresSql and its components should be installed in ubuntu system. 2. Check what databases are available in postgresSql through terminal 3. Login to

European characters like è é å ñ ü ,à, è, ì, ò, ù – À, È, Ì, Ò, Ù, ™, © ,• , ∑, α, β, «, » do not get inserted correctly in MySQL by default. To fix it,