How do I get the exit code while directing the command output to a file?

I am canceling the mysql command on purpose to have error exit code. In the command below, the exit code is being 0 successful because of the tee. How can I solve this?

mysql --defaults-extra-file=/etc/my.cnf.d/.mylogin.cnf -e"use radius; call sp_monthly_table_backup(@Msg);" | tee -a $CLEARLOG $ZBXLOG > /dev/null;

EXITCODE=$(echo $?);

I am canceling the mysql command on purpose to have error exit code.

Why? What are you trying to accomplish?

sleep 10 | tee -a myfile.txt
echo $?
0

sleep 10 | tee -a myfile.txt
^C
echo $?
130

Give more info, maybe someone can shove you in the right direction.

#2 brings up the question: How are you “canceling” the MySQL?

Just to be clear, you only get the exit code for the last cmd in a pipeline, so in your case, the tee cmd ...

exit_code=$?

No need for echo & sub-shells - plenty of examples on the web

I got what I wanted with echo $ {PIPESTATUS [0]}

yes, that is the array PIPESTATUS, but you need to use first set -o pipefail, otherwise it will not work.