Sometimes you may need to compare null values in MySQL. Here is how to compare null values in MySQL for Null Comparison.
How to Compare Null Values in MySQL
MySQL
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 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.
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 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.
MySQL Change Collation of All Tables
MySQL collation allows you to store different characters in databases. Here’s how to change collation of all tables in MySQL.