Snippets

Switch case (INSERT)

[crayon-69303d45e71df779984313/] [crayon-69303d45e71ea924158883/]  

7 years ago

KILL ALL EXISTING CONNECTION FROM DB – PostgreSQL

[crayon-69303d45e7d8d797151235/]  

7 years ago

Creating a copy of a database in PostgreSQL

[crayon-69303d45e7f14413169129/]  

7 years ago

Backup & Restore Database in PostgreSQL

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

7 years ago

Concatenate multiple MySQL rows into one field

[crayon-69303d45e8721846589371/]  

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-69303d45e8832583085947/]  

7 years ago

UPDATE query based on SELECT Query

MySQL update join syntax: [crayon-69303d45e893f474450388/] ANSI SQL syntax: [crayon-69303d45e8942291650328/] or [crayon-69303d45e8944995095488/]  

7 years ago