OSDN Git Service
(root)
/
opengatem
/
opengatem.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
fixed error at ndp request
[opengatem/opengatem.git]
/
sqlscript
/
updatescript2
1
/*
2
Change the mac address to deleted mode
3
for device passing 6 month after limit date.
4
Use as
5
mysql < updatescript2
6
*/
7
use opengatem;
8
update macaddrs set status='D' where limitDate<adddate(now(), interval -6 month) and status!='D';
9