Here is how to update a column based on another column in SQL Server, MySQL, PostgreSQL.
MySQL
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 Alter Column From NULL to NOT NULL
Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.
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.
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.
How To Copy Table in MySQL
Sometimes you may need to copy table in MySQL or clone table in MySQL. Here’s how to copy table in MySQL.