Sometimes you may need to create user in PostgreSQL. Here are the steps to create user in PostgreSQL.
How to Create User in PostgreSQL
How to Reset MySQL Root Password
Sometimes you may need to change root password or reset root password in MySQL. Here’s how to reset root password in MySQL if you forgot root password.
How To Delete Stored Procedure in MySQL
MySQL Change User Password
Sometimes you may need to recover MySQL password or reset user password if you forgot user password. Here’s how to change user password in MySQL.
MySQL Cast as Boolean
Sometimes you may need to cast as boolean in MySQL. Here’s how to cast string as boolean and cast int as boolean.
MySQL CAST vs CONVERT
MySQL Convert Function
Sometimes you may need to convert data in MySQL. Here’s how to convert data in MySQL using MySQL convert function.
MySQL CAST – How to Type Cast in MySQL
Sometimes you may need to typecast one data into another in MySQL. Here’s how to cast data using MySQL CAST function.
MySQL Rollback Query
Sometimes you may need to undo MySQL changes for your databases. Here’s how to rollback changes using MySQL Rollback query command.
How to Use MySQL Rollup
Sometimes you may need to calculate totals in MySQL. Here’s how to use MySQL rollup to calculate total in MySQL.