Here is how to compare two columns in MySQL. You can compare two columns from same table or from different table.
Author: Sreeram Sreenivasan
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.
How to Get Every Nth Row in MySQL
How to Add Auto Increment Column in Existing Table in MySQL
Auto increment column automatically increases on adding new rows. Here’s how to ad auto increment column in existing table in MySQL.
Top Free Database Design Tools
Database design tools allow you to design database schema, and simplify database administration. Here are the top free database design tools for your business.
PostgreSQL Security Best Practices
PostgreSQL Security Best Practices and Checklist will help you secure PostgreSQL database against security vulnerabilities.
How to Find nth Row in MySQL
Sometimes you may need to select nth row or get nth row in MySQL. Here’s how to find nth row in MySQL.
How to Enable SSL in PostgreSQL
How to Replicate MySQL Database to Another Server
MySQL Replication Configuration – here are the steps to replicate MySQL database to another server. Copy MySQL database from one sever to another.
How to Enable SSL/TLS for MySQL in Ubuntu
MySQL allows SSL/TLS connections with SSL certificate. Here is how to enable SSL/TLS for MySQL for Ubuntu.