Auto increment column automatically increases on adding new rows. Here’s how to ad auto increment column in existing table in MySQL.
Top 5 Free Database Design Tools
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
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.
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.
Top Database Blogs to Follow
Database blogs provide useful resources, tips and tutorials. Here are the top databases to follow for web developers, database administrators and tech founders.
How To Select Records from Last 24 Hours using PostgreSQL
Sometimes you may need to get rows from last 1 day or last 24 hours. Here’s how to select records from last 24 hours using PostgreSQL.