Truncate all tables in a mysql or mariadb database shell script

reset_database

#! /bin/bash
############################################ 
# don't forget to chmod +x reset_database  #
# usage: ./reset_database dbname           #
# enter db password when prompted          #
############################################

# set the database name
DATABASE_NAME=$1

# get the db user from the keyboard
read -p "DB User: " DBUSER

#get the db password from the keyboard
read -s -p "DB Password: " DBPASSWORD
# just to move to the next line
echo ""
 # truncate all the tables in one go
mysql -Nse 'show tables' -D $DATABASE_NAME -u$DBUSER -p$DBPASSWORD | while read table; do echo "SET FOREIGN_KEY_CHECKS = 0;truncate table \`$table\`;SET FOREIGN_KEY_CHECKS = 1;"; done | mysql $DATABASE_NAME -u$DBUSER -p$DBPASSWORD
exit 0

where should i write these commands

I tried this on different DBs. but its showing ERROR 1146 (42S02) at line 402: Table 'dbname.inventory_stock_1' doesn't exist