MySQL Archives - Page 13 of 17 - SQL Authority with Pinal Dave

MySQL – How to Detect Current Time Zone Name in MySQL

February 16, 2014

MySQL developers and DBA often face a very simple challenge when they have to retrieve the time zone of the session which they are connected to. If you look at MySQL documentation and search engine there are many different ways to do the same. In this blog post, I will…

MySQL – When to Use TIMESTAMP or DATETIME – Difference Between TIMESTAMP or DATETIME

February 14, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL DateTime

This is a one of the most popular question, I often receive when MySQL Developers are creating a database. There are multiple datatypes which can store DateTime datatype in MySQL. The usual confusion comes up between DATETIME and TIMESTAMP. DATETIME and TIMESTAMP – both of them can store datetime data…

MySQL – Learning Online MySQL Workbench Guided Tour – Pluralsight Course

February 4, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

MySQL Workbench is the default IDE for MySQL and the most popular IDE among MySQL Developers and Administrator. There are three major sections in MySQL Workbench. 1) Developement – Developer can perform various activities related to SQL development in this area. For example – building queries, executing queries, etc 2)…

MySQL – Download MySQL Workbench Shortcut in PDF

February 2, 2014

Pinal Dave

SQL, SQL Tips and Tricks

Cheatsheet, MySQL, SQL Shortcut

MySQL Workbench is default IDE for MySQL and it is available to download for free on MySQL’s website. It is a fully featured IDE with three major sections. 1) SQL Development 2) SQL Administration and 3) Data Modeling. Each section is quite big on its own. There are plenty of…

MYSQL – Could not Drop Object [Content] (‘Cannot delete or update a parent row: a foreign key constraint fails’, 1217) DROP DATABASE DatabaseName

February 1, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Error Messages

If you are using MySQL following, you must have faced following error when you want to drop a table or database. This error happens when we try to drop a table or database which has a foreign key constraint associated with another table, schema or database. Could not Drop Object…

MySQL – Change the Limit of Row Retrieved in MySQL Workbench

January 12, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Server

MySQL Workbench is default IDE for MySQL. It can be installed on Windows, Linux or Mac OSX. Here is the one question which new users of MySQL Workbench often ask –

“When I execute my SQL Query from my application, it retrieves correct numbers of the row, but when I execute the same query in MySQL Workbench it retrieves only 1000 records. What is the reason behind it?”

MySQL – Learn MySQL Online – 8 MySQL Courses at Pluralsight

January 10, 2014

Pinal Dave

SQL Tips and Tricks

MySQL, Pluralsight

At the beginning of the year 2013, I had decided to widen my focus with related to database. I have been writing a lot about SQL Server throughout this day, but the reality is that I have been equally focused on MySQL as well. A few years ago, MySQL was…