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.
Here is how to compare two columns in MySQL. You can compare two columns from same table or from different table.
Sometimes you may need to compare two schemas in PostgreSQL. Here’s how to compare schemas in PostgreSQL.
Sometimes you may need to get every nth row in MySQL. Here’s how to return every nth row in MySQL.
Auto increment column automatically increases on adding new rows. Here’s how to ad auto increment column in existing table in MySQL.
Database design tools allow you to design database schema, and simplify database administration. Here are the top 5 free database design tools for your business.
PostgreSQL Security Best Practices and Checklist will help you secure PostgreSQL database against security vulnerabilities.
Sometimes you may need to select nth row or get nth row in MySQL. Here’s how to find nth row in MySQL.
PostgreSQL supports secure SSL/TLS database connections. Here is how to enable SSL in PostgreSQL.
MySQL Replication Configuration – here are the steps to replicate MySQL database to another server. Copy MySQL database from one sever to another.