Sometimes you need to round timestamp to hour, minute, day, seconds, month. Here is how to round timestamp in MySQL
How to Round Timestamp in MySQL
MySQL
How To Rename Table in 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 Update Multiple Columns in MySQL
Sometimes you may need to update multiple columns in MySQL. Here is how to update multiple columns in 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.
