MySQL Scheduler (also called Event Scheduler) lets you to schedule the tasks or events at a specified time. MySQL Event Scheduler could be very useful if you want to follow a specific schedule (predefined time or regular intervals) to execute one or more queries. When we create an Event, MySQL would be internally creating a named […]

As per MySQL docs, MySQL Collation is a set of rules for comparing characters in a character set. MySQL collation affect how Strings are sorted and compared with each other. While creating a database table, you will have multiple collation options to choose from. Your choice of collation while creating a database mainly depends on […]