Switch case (INSERT)

[crayon-663dfe0246af4633445010/] [crayon-663dfe0246aff415363270/]  

6 years ago

KILL ALL EXISTING CONNECTION FROM DB – PostgreSQL

[crayon-663dfe0246f67456890735/]  

6 years ago

Creating a copy of a database in PostgreSQL

[crayon-663dfe0247068781625530/]  

6 years ago

Backup & Restore Database in PostgreSQL

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

6 years ago

Concatenate multiple MySQL rows into one field

[crayon-663dfe0247823999958603/]  

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-663dfe0247973127093985/]  

6 years ago

UPDATE query based on SELECT Query

MySQL update join syntax: [crayon-663dfe0247a66574004765/] ANSI SQL syntax: [crayon-663dfe0247a6c396421828/] or [crayon-663dfe0247a6e933866414/]  

6 years ago