Need the current time zone of the MySQL server you are connected to? One simple query with @@system_time_zone returns the time zone name.
MySQL – When to Use TIMESTAMP or DATETIME – Difference Between TIMESTAMP or DATETIME
Confused about TIMESTAMP or DATETIME in MySQL? I explain the two factors, starting with supported range, that help you decide which one to use.
MySQL – Learning Online MySQL Workbench Guided Tour – Pluralsight Course
MySQL Workbench has three sections: development, administration and data modeling. My Pluralsight course, MySQL Workbench Guided Tour, walks through each one.
MySQL – Download MySQL Workbench Shortcut in PDF
Download my MySQL Workbench shortcut cheat sheet in PDF. Print it, keep it on your desk and use it for development, administration and data modeling.
MYSQL – Could not Drop Object [Content] (‘Cannot delete or update a parent row: a foreign key constraint fails’, 1217) DROP DATABASE DatabaseName
Cannot drop a MySQL table or database because a foreign key constraint fails with error 1217? Turn off FOREIGN_KEY_CHECKS, drop it, then turn checks back on.
MySQL – Change the Limit of Row Retrieved in MySQL Workbench
Why does a query return every row in your app but only 1000 in MySQL Workbench? It limits rows by default, and here is how to change that limit.
MySQL – Learn MySQL Online – 8 MySQL Courses at Pluralsight
Want to learn MySQL online? I built 8 MySQL video courses at Pluralsight that are easy to understand. Here is the full list of them.