摘要:
time:00:00:01-01:00:00 function compareSetHours(time) { var result = false var times = time.split('-') if (times.length 2) { var date = new Date() var 阅读全文
摘要:
[HttpGet("ExportPolicy")] public FileStreamResult ExportPolicy(string id) { var data = service.ExportPolicy(id); Stream stream = new MemoryStream(data 阅读全文
摘要:
查询数据库中有多少个表: SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema ='soc_common' GROUP BY table_schema; 以下代码亲测:(比较两个数 阅读全文
摘要:
查找间隔天数: select CURDATE() as date union all select DATE_SUB(CURDATE(),interval 7 day) as date IFNULL() :函数用于判断第一个表达式是否为 NULL,如果为 NULL 则返回第二个参数的值,如果不为 N 阅读全文