Switch case (INSERT)

[crayon-67a5b4bb49235039931773/] [crayon-67a5b4bb4923d820044552/]  

6 years ago

KILL ALL EXISTING CONNECTION FROM DB – PostgreSQL

[crayon-67a5b4bb495b4619227413/]  

6 years ago

Creating a copy of a database in PostgreSQL

[crayon-67a5b4bb49657175289711/]  

6 years ago

Backup & Restore Database in PostgreSQL

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

6 years ago

Concatenate multiple MySQL rows into one field

[crayon-67a5b4bb49a40041065727/]  

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-67a5b4bb49ab8120507847/]  

6 years ago

UPDATE query based on SELECT Query

MySQL update join syntax: [crayon-67a5b4bb49b3e484328638/] ANSI SQL syntax: [crayon-67a5b4bb49b40875312581/] or [crayon-67a5b4bb49b42531644170/]  

7 years ago