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 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 Setup Remote Connection to PostgreSQL
You can easily enable remote access in PostgreSQL databases. Here is how to setup remote connection in PostgreSQL.
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.
Top Data Modeling Tools for SQL Server
Data modeling tools help with database design and administration. Here are the top 5 data modeling tools for SQL Server.
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 Compare Two Schemas in PostgreSQL
Sometimes you may need to compare two schemas in PostgreSQL. Here’s how to compare schemas in PostgreSQL.
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.
