Snippets

Switch case (INSERT)

[crayon-67a5b72d254b5038981911/] [crayon-67a5b72d254bc669046627/]  

6 years ago

KILL ALL EXISTING CONNECTION FROM DB – PostgreSQL

[crayon-67a5b72d25754157207912/]  

6 years ago

Creating a copy of a database in PostgreSQL

[crayon-67a5b72d257d5550524175/]  

6 years ago

Backup & Restore Database in PostgreSQL

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

6 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…

6 years ago

MySql Login, Database & User Creation

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

6 years ago

Concatenate multiple MySQL rows into one field

[crayon-67a5b72d25b5d140786424/]  

6 years ago

SQL Introduction

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

6 years ago

MySQL Search and Replace Query

[crayon-67a5b72d25bff274910586/]  

6 years ago

UPDATE query based on SELECT Query

MySQL update join syntax: [crayon-67a5b72d25c89414461835/] ANSI SQL syntax: [crayon-67a5b72d25c8b770738072/] or [crayon-67a5b72d25c8d370771001/]  

7 years ago