SQL

Structured Query Language

How To Set Up Master And Slave MYSQL

In this tutorial I am going to teach you one of the most important MySQL techniques that you must use in your software development. Today huge amount of business use MySQL as their data base. Imagine if their database corrupted what would be happen ?, If your server crashed what word you do ? So we must use database backup technique to overcome those issues. Now I am going to explain you one of

Some SQL Query Optimization Technique

Modern day software application has millions of concurrent users. Development of efficiently serviceable application needs huge amount of effort, usage of lot of tools and techniques. Software developers always try to improve performance of the application by improving design, cording and database development. When we consider database development query optimization and evaluation techniques are

Basic SQL Syntax, Structures, Key words and Queries

Introduction: This tutorial is going to be covering the basic syntax of SQL queries in MySQL and MySQLi. MySQL and MySQLi...? MySQLi is an updated version of the original MySQL language. Both versions use almost exactly the same syntax although MySQLi should be used as it is more secure, updated and reliable. Query Syntax: To create a MySQL(i) query, you combine different MySQL(i) keywords together and give it the information required to parse for the necessary returned information.

PHP/MySQL/HTML Login Form

Introduction: This tutorial will cover creating a login form with PHP/MySQL/HTMl. Pre-creation: First you need to have some user accounts stored in a database, you can check out my profile for a tutorial on creating a register form. Steps of Creation: Step 1: First we need to connect to the database holding the user accounts... mysqli_connect uses the parameters; server, username, password* Step 2

Detecting and Deleting Duplicate Records in SQL Server 2005 and Above

Most of the time, we encounter duplicate records in our database. And it's not easy to delete it if you don't have enough knowledge about SQL Statement. This code will help you detect and delete duplicate records in SQL Server 2005 and above. (These commands only works on sql server 2005 or higher) Create table create table example(id int identity(1,1),name varchar(20),class varchar(20)); (Here

4 Simple Steps to Emulating Real Sequences in MySQL

If all you want to do is create a unique ID for a record, the auto_increment feature in MySQL will do the job nicely. Sometimes, however, you need more functionality. Unfortunately, unlike Oracle or PostgreSQL, MySQL doesn't have native support for the nextval() function, so creating real sequences is a little more challenging. First, we need to define what we want the nextval() function to achieve. We want to be able to begin the sequence with any number, and auto increment in multiples of any number, not just 1, including negative integers (-1 for example).

How to Concatenate Column Values from Multiple Rows

Just want to share with you on how to concatenate or combine one or more values from multiple rows. This SQL code is part of my “Online Hotel Reservation” project.

The idea here is to group column values while concatenating the other column to avoid duplicate records.

Here’s an example:

I have the following record on my table: