How to “select * from table from database” with -e?
Got it!

Just had to add the database name before the execute flag (-e) and the sql statement.,

mysql -u root db01 -e “select * from table1 limit 1”


Where,


db01 is the database name 
table1 is the table name
limit 1 for showing only 1 record