Database Archives - Page 4 of 6

Introduction to DataBase Isolation Levels

Author - Ishpreet Kaur
|
0 Comments
|

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 access or modification by number of users at a Read more…

PHP | Load Data Infile to insert csv data into Mysql with PHP

Author - Webner

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 records in mysql table with php Read more…

Eclipse SVN | Working Copy XXXX Locked during commit

Author - Webner
|
0 Comments
|

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 files”. But you may have to solve it Read more…

Heroku | The datasource configuration “default” was not found in database.php

Author - Webner

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 app code we renamed the database.php.default file Read more…

Sorting Alphanumeric Data in PHP

Author - Kritika Sood

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 right. So it places c10 before c2 as 1&lt Read more…

CakePHP | How to handle special characters (like apostrophes) in queries

Author - Ishpreet Kaur

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 have special characters in their Read more…

MySQL | Unable to create foreign key between two tables

Author - Webner
|
0 Comments
|

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.

Fields in both the tables:
Table 1
Fields
Indexes
Id Read more…

PostgreSQL | Create a connection to a local postgres database in pgAdmin |||

Author - Ishpreet Kaur

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 PostresSql server in terminal using following command:
sudo -u postgres psql
With Read more…

MySQL | How to support European characters on database level

Author - Parminder Kaur

European characters like è é å ñ ü ,à, è, ì, ò, ù – À, È, Ì, Ò, Ù, ™, © ,• , ∑, α, β, «, » do not get inserted correctly in MySQL by default. To fix it, we need to change the character set (fixed collection of symbols) and collation (set of rules that determine how data is sorted and compared).

To insert and retrieve european characters change character set to utf Read more…

MYSQL | #1293 – Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP

Author - Ishpreet Kaur

Suppose we want to have columns created_date and last_modified_time with default timestamp in any table in MySQL/Phpmyadmin.

Let us take an example of Students table.

Create table Students using following query :
CREATE TABLE students(
id INT AUTO_INCREMENT PRIMARY KEY ,
first_name varchar(20) NOT NULL,
last_name varchar(20) NOT NULL Read more…

Selenium | How to perform search with Selenium script

Author - Namisha

In this post I will give an example of how to perform search with Selenium script on a webpage. Below is the screenshot of the webpage:

Code to automatically enter a keyword “paint” in the textbox and then click Search button (or enter key) is given below. Go through the Read more…

How to add combobox in editable datagrid using jQuery EasyUI

Author - Webner

Following is the code to add Combobox in editable data grid:

Index.html:
<table id=”dg” title=” Combobox in editable datagrid ” style=”width:100%;height:700px”
toolbar=”#toolbar” pagination=”true” rownumbers=”true” fitColumns=”false” singleSelect=”true” autoSave=”true” data-options=”pageSize:50″>
<thead>
&lt Read more…

Microsoft SQL Server | MySQL LIMIT equivalent in Microsoft SQL Server

Author - Kailash
|
0 Comments
|

Suppose you want to retrieve values from row from 5 to 10 from a table in SQL server. Since LIMIT keyword does not work in it so we can use any of these 2 alternative methods:

Solution 1 :

SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY name) as row FROM TableName Read more…

CakePHP bake: SQLSTATE[42S02]: Base table or view not found

Author - Rita

While running cake bake command for cakephp 3.0 we got the following error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘tablename .columnname’ doesn’t exist

The culprit was a column with name test_id in one of the tables. As per bake command’s conventions about foreign Read more…

Selenium | Mass CSV file generation by fetching data from database

Author - Webner
|
0 Comments
|

In a project we are working on there are large number of pdf files for which field mapping data is stored in the database. In this project pdf forms are auto filled with data from Salesforce. Which PDF form field is mapped to which corresponding Salesforce object or field is Read more…

MySQL | A short note on database indexes

Author - Webner
|
0 Comments
|

Index is used for storing values for a specific column in a table. An index is created on a column of a table and used to speed up search queries.

For Example :

Suppose we have a database table called Users with three columns – User_Name, User_Age, and User_Address. Assume that this Read more…

Database Connectivity with Selenium Webdriver

Author - Webner

How to connect to Mysql in Selenium script?

Step 1: Import Mysql connector (JDBC driver):

Download connector from:

Find-ur-pal

Download this jar file and import in Eclipse : MySQL-connector-java-5.1.18-bin.jar

Follow these steps in Eclipse:

Add the downloaded Jar to your Read more…

Mysql Workbench | How to copy Remote database into your local machine

Author - Rita

1.  Select Database: Schema Transfer Wizard from the Mysql workbench menu bar. You will see schema transfer wizard on your screen as below:

Click on Start the Wizard option.

2.  Connection Selection: Now select your source and destination location to copy database:

If you want to Read more…

MySQL | Insert multiple records and update if record(s) already exist in a single query

Author - Ishpreet Kaur
|
0 Comments
|

In MySQL, we generally perform insert, update, select and delete operations on records of table. Multiple Insert operation can also be easily performed on table.

Take an example of Employees table with fields:

Multiple records can be inserted in Employees table in a single query using following MySQL query :

INSERT Read more…

MySQL | Upgrade MySQL 5.5 to 5.6 in Ubuntu 14.04

Author - Webner

MySql 5.5 is the default version for Ubuntu 14.04

Steps to Upgrade the mysql-server

If you have existing database in Mysql 5.5. It should be migrated automatically.

Take the backup of existing databases:

mysql> mysqldump –lock-all-tables -u root -p -all-databases > backup Read more…