
Here is how to update a column based on another column in SQL Server, MySQL, PostgreSQL.
Sometimes you may need to find PostgreSQL version or get PostgreSQL version. Here is how to check PostgreSQL version for your database.
Sometimes you may need to update multiple columns in MySQL. Here is how to update multiple columns 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.
Sometimes you may need to change user to superuser in PostgreSQL. Here is alter user to superuser in PostgreSQL.
Sometimes you may need to restrict access to database in PostgreSQL. Here is how to limit access to database in PostgreSQL.
Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.
Sometimes MySQL gives incorrect string value error. Here is how to fix incorrect string value in MySQL.
You can easily enable remote access in PostgreSQL databases. Here is how to setup remote connection in PostgreSQL.
MySQL blogs and websites provide useful tips and tutorials for database administrators and developers. Here are the top MySQL blogs and websites for your reference.