Execute MySQL statement in shell script

After the table is built by hash, the data volume of the table is 2048 large, how to verify the table is successful?

Logical generate table name this part will not be written. As long as you can build the table successfully, this part of the script must be there. So how do you execute a selec query in the shell and return it?

Just add in the script

mysql-h [IP]-p [port]-u[username]-p[password]-E ' select COUNT (1) from Dbname.tablename; '

Returning results will naturally output the returned results

Execute MySQL statement in shell script