Best method to pull data from MariaDB

Hi,

I have to pull data from MariaDB on a regular basis - weekly.

What is the best method to perform this? Via cronjob?
How to replace the dates on weekly basis in the SQL for extracting?

Thanks.

3 Likes

The simplest way to retrieve data from MariaDB is to use the SELECT statement.