MySQL Random Row

Last Updated on: September 16, 2022 If you want to reseed your primary key (i.e. change the value of the next primary key generated), you can do it like this: This is useful for starting a new site, and you don’t want to leave hints that you have just launched. For example, if you sign…

Last Updated on: October 11, 2022 Even the best MySQL implementation will sometimes have problems with processes taking too long and hogging the CPU and memory. This will have a knock-on effect on any other processes running on the server and can have a significant effect on performance. In an ideal world, you could just…

Last Updated on: October 11, 2022 Security is an essential consideration for any computer system and MySQL is no exception to this rule. One big security problem that administrators can often overlook is obsolete accounts. These accounts were created for people who no longer use them and are big security holes waiting to be found….

Last Updated on: September 15, 2022 One of the most critical tasks for a MySQL administrator is reliably backing up and restoring databases. This, of course, helps to prevent data loss in the event of a hardware failure, data corruption… or a little accident. Most modern hosting/server solutions have some kind of database backup solution…

Working with dates and times in MySQL is straightforward and there are several MySQL functions to do the calculations for you. Some of the most common requirements are to calculate the current date and time, and this can be done with the CURRENT_DATE() and NOW() functions like this: Sometimes you might want to extract some…

Last Updated on: October 11, 2022 It does not matter what data is stored in your database, you want to prevent unauthorized access. If the data is not secure, then anyone with the time and motivation can potentially access it over the internet. Once they are in your database, they can take all your data…