Sometimes you may need to run multiple MySQL server on single machine. Here is how to run multiple MySQL instances on same machine.
How to Run Multiple MySQL Instances on Same Machine
How To Change User Password in PostgreSQL
Sometimes you may need to change user password in PostgreSQL. Here are the steps to change user password in PostgreSQL.
How To Create User With Superuser Privileges in PostgreSQL
You need to create superuser for database administration. Here is how to create user with superuser privileges in PostgreSQL.
How to Insert Multiple Rows in MySQL
Sometimes you may need to insert multiple rows in MySQL. Here is how to insert multiple rows in MySQL.
How to List All Users in PostgreSQL
How To Update a Column Based on Another Column in SQL
How to Check PostgreSQL version
Sometimes you may need to find PostgreSQL version or get PostgreSQL version. Here is how to check PostgreSQL version for your database.
How To Update Multiple Columns in MySQL
Sometimes you may need to update multiple columns in MySQL. Here is how to update multiple columns in MySQL.
How to Escape Single Quote, Special Characters in MySQL
Sometimes you may need to store string with single quote, double quote, backticks and special characters. Here is how to escape single quote, special characters in MySQL.
How To Change User to Superuser in PostgreSQL
Sometimes you may need to change user to superuser in PostgreSQL. Here is alter user to superuser in PostgreSQL.
