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

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…
Read More

MySQL – Change the Limit of Row Retrieved in MySQL Workbench

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?”

Read More