From bash script (Debian Bookworm) login and query to MariaDB

Hi guys,

I need to write in bash a script which do these things:

1) Login to MariaDB;
2) Truncate a table to make it empty;
3) Import data from a file to this table.

I found this guide 
https://notearena.com/lesson/how-to-access-databasemysql-mariadb-in-linux-shell-scripting/ 
and I'd like to know if it's the right way! :)

Now I do everything manually...

Regards.
^Bart