Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.
How to Fix Incorrect String Value in MySQL
Sometimes MySQL gives incorrect string value error. Here is how to fix incorrect string value in MySQL.
How to Setup Remote Connection to PostgreSQL
You can easily enable remote access in PostgreSQL databases. Here is how to setup remote connection in PostgreSQL.
Top MySQL Blogs and Websites for Database Administrators
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.
How to Change Column Size in MySQL
Sometimes you may need to change column size in MySQL or change field length in MySQL. Here is how to change column size in MySQL.
How To List Databases and Tables in PostgreSQL
How to Store JSON Data in MySQL
MySQL allows you to store JSON data, insert JSON string into MySQL, and extract JSON. Here is how to store JSON data in MySQL.
Top 5 Data Modeling Tools for SQL Server
Data modeling tools help with database design and administration. Here are the top 5 data modeling tools for SQL Server.
How to Compare Null Values in MySQL
Sometimes you may need to compare null values in MySQL. Here is how to compare null values in MySQL for Null Comparison.
How to Create Read Only User in PostgreSQL
Read Only user has limited permissions and database access. Here is how to create read only user in PostgreSQL for reporting purposes.