Sometimes you may need to update multiple columns in MySQL. Here is how to update multiple columns in MySQL.
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 Fix Incorrect String Value in MySQL
Sometimes MySQL gives incorrect string value error. Here is how to fix incorrect string value in MySQL.
Top MySQL Blogs and Websites for Database Administrators
MySQL blogs and websites provide useful tips and tutorials for database administrators and developers. Here are the top MySQL blogs and websites for your reference.
How to Change Column Size in MySQL
Sometimes you may need to change column size in MySQL or change field length in MySQL. Here is how to change column size 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 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.