Sometimes you may need to insert multiple rows in MySQL. Here is how to insert multiple rows in MySQL.
How to Insert Multiple Rows in MySQL
How to Copy Data From One Table to Another in SQL
Sometimes you may need to copy data from one table to another using SQL. Here is how to copy data from one table to another in SQL.
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.
How to Limit Access to Database in PostgreSQL
Sometimes you may need to restrict access to database in PostgreSQL. Here is how to limit access to database in PostgreSQL.
How To Alter Column From NULL to NOT NULL
Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.