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.
How to Compare Two Rows from Same Table
Sometimes you may need to compare consecutive rows or compare two rows from same table. Here is how to compare successive rows by comparing each row with previous row.
How to Compare Two Columns in MySQL
Here is how to compare two columns in MySQL. You can compare two columns from same table or from different table.
How to Compare Two Schemas in PostgreSQL
Sometimes you may need to compare two schemas in PostgreSQL. Here’s how to compare schemas in PostgreSQL.