Snippets

Switch case (INSERT)

[crayon-68be0b2102b3a086578368/] [crayon-68be0b2102b5b506628291/]  

7 years ago

KILL ALL EXISTING CONNECTION FROM DB – PostgreSQL

[crayon-68be0b2103381988925877/]  

7 years ago

Creating a copy of a database in PostgreSQL

[crayon-68be0b21035cc215978922/]  

7 years ago

Backup & Restore Database in PostgreSQL

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

7 years ago

Concatenate multiple MySQL rows into one field

[crayon-68be0b21040a9806990953/]  

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-68be0b2104265023247035/]  

7 years ago

UPDATE query based on SELECT Query

MySQL update join syntax: [crayon-68be0b21044b5838132730/] ANSI SQL syntax: [crayon-68be0b21044ba256924653/] or [crayon-68be0b21044bd792335048/]  

7 years ago