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

Popular posts from this blog

IF statement in MySQL trigger -

c++ - What does MSC in "// appease MSC" comments mean? -

javascript - Blogger related post gadget image Resize s72-c [ Need Expert Help ] -