Skip to content

Instantly share code, notes, and snippets.

@chikatambun

chikatambun/gist:5a1d6d7c7d3e94c973b9

Created March 30, 2015 03:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save chikatambun/5a1d6d7c7d3e94c973b9 to your computer and use it in GitHub Desktop.
Save chikatambun/5a1d6d7c7d3e94c973b9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> select count(*) from radacct where TimeStop is NULL;
+----------+
| count(*) |
+----------+
| 47318 |
+----------+
1 row in set (0.04 sec)
mysql> select distinct username from radacct where TimeStop is NULL;
...
| bromo |
| argopuro |
| arjuno |
+--------------------------+
39 rows in set (0.98 sec)
mysql> update radacct set TimeStop=NOW() where TimeStop is NULL;
Query OK, 0 rows affected (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment