You may have been in a situation which you may need to figure out what is the PRIMARY key field of a given table. Or even if it is a compound key what are the columns building the PRIMARY key. This usually helps a lot when you’re making some generic tools to do some jobs on a given table.
Continue ReadingNotes to consider when using MySQLdb API for Python to use String Formatted Parameterized placeholders.
Continue ReadingMySQL Trigger is a powerful tool to provide the data consistency and accuracy among your tables or Database in general. The only disadvantage among Triggers is that they’re not able to update the same table they’re based on.
Continue ReadingMySQL FEDERATED Table is a proxy to a regular table located in another DB server. You will see the table as a local table while it’s being located in another MySQL Database Server.
Continue ReadingHave you ever encountered “The user specified as a definer : (‘no_such_user’@’no_such_host’) is invalid or unregistered”?
Continue ReadingIf you need the results from you query to be grouped by date/hour/minute, you may need a bit of sql trick.
Continue Reading