mysql run query but dont show results -
i have mysql table large number of rows (10m)
from mysql client, want run query not print results. because though query runs in 15 seconds, printing results on console takes many minutes.
how can achieve this?
edit: query following:
select user_id, count(*) ct user_geo_loc group user_id, lat, lng; edit 2: @ end of execution, mysql client prints following
9950710 rows in set (9.31 sec) i want find out time not print results (which takes 15 minutes)
when on linux, redirect output /dev/null prevent output. this:
mysql -u username -p database -e "select * table" > /dev/null on windows equivalent be:
mysql -u username -p database -e "select * table" > nul please note: thing printed on console errors, prevent this, have redirect stderr stdout adding 2>&1 end (linux)
Comments
Post a Comment