Sometimes you may need to change a table name in MySQL. Here is how to rename table in MySQL.
MySQL
How to Run Multiple MySQL Instances on Same Machine
Sometimes you may need to run multiple MySQL server on single machine. Here is how to run multiple MySQL instances on same machine.
How to Insert Multiple Rows in MySQL
Sometimes you may need to insert multiple rows in MySQL. Here is how to insert multiple rows in MySQL.
How To Update a Column Based on Another Column in SQL
How to Escape Single Quote, Special Characters in MySQL
Sometimes you may need to store string with single quote, double quote, backticks and special characters. Here is how to escape single quote, special characters in MySQL.
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.
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 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 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.