Switch case (INSERT)

[crayon-69366208d0fac730591042/] [crayon-69366208d0fb2593225086/]  

7 years ago

KILL ALL EXISTING CONNECTION FROM DB – PostgreSQL

[crayon-69366208d1280606371756/]  

7 years ago

Creating a copy of a database in PostgreSQL

[crayon-69366208d132e116450777/]  

7 years ago

Backup & Restore Database in PostgreSQL

1) Backup data with pg_dump [crayon-69366208d13b0844845247/] 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-69366208d15ea403580156/] Enter password:- Enter your mysql password Step 2: Create…

7 years ago

Concatenate multiple MySQL rows into one field

[crayon-69366208d16b5500656750/]  

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-69366208d1727643037028/]  

7 years ago

UPDATE query based on SELECT Query

MySQL update join syntax: [crayon-69366208d1797903983736/] ANSI SQL syntax: [crayon-69366208d1798632463106/] or [crayon-69366208d179a032512826/]  

7 years ago