Using MySQL’s Event Scheduler (No cron job)!
In MySQL, you can use internal Event Scheduler to periodically refresh or update table data at specified intervals. Here's a step-by-step guide.
Tag: database
How to get all indexes of a table in Laravel
Get all indexes of a table in Laravel
Backup your database periodically to free cloud storage
You want to keep a periodical, automatic backup of your database. And, for safety, you are thinking to keep these backups to a (preferably free) cloud storage. ...
From Oracle TO_DATE to MySQL STR_TO_DATE
I had to import a huge Oracle database dump into MySQL database today. One major problem in doing this was, TO_DATE function of Oracle (used to convert string t...