Switch case (INSERT)

[crayon-68b7d6d953589016406240/] [crayon-68b7d6d953594201908610/]  

7 years ago

KILL ALL EXISTING CONNECTION FROM DB – PostgreSQL

[crayon-68b7d6d953981642260537/]  

7 years ago

Creating a copy of a database in PostgreSQL

[crayon-68b7d6d953ad7521091865/]  

7 years ago

Backup & Restore Database in PostgreSQL

1) Backup data with pg_dump [crayon-68b7d6d953c8d665535532/] To list all of the available options of pg_dump , please issue following command.…

7 years ago

How to Back Up and Restore a MySQL Database

If you're storing anything in MySQL databases that you do not want to lose, it is very important to make regular…

7 years ago

MySql Login, Database & User Creation

Step 1: Login to MySQL ( you will need an account ) [crayon-68b7d6d95408c189613830/] Enter password:- Enter your mysql password Step 2: Create…

7 years ago

Concatenate multiple MySQL rows into one field

[crayon-68b7d6d95453c665636917/]  

7 years ago

SQL Introduction

SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for…

7 years ago

MySQL Search and Replace Query

[crayon-68b7d6d954875482279869/]  

7 years ago

UPDATE query based on SELECT Query

MySQL update join syntax: [crayon-68b7d6d9549c6716665562/] ANSI SQL syntax: [crayon-68b7d6d9549ca869642034/] or [crayon-68b7d6d9549cc598789413/]  

7 years ago