摘要:
查询当天数据 select * from tab where FROM_UNIXTIME(fabutime, '%Y%m%d') = 20121217; mysql TO_DAYS(date) 函数 TO_DAYS(date) 给定一个日期date, 返回一个天数 (从年份0开始的天数 )。 最近一 阅读全文
摘要:
value = input('请输入您的IP地址:') def foo(name): lists = name.split('.') if len(lists) != 4: return '该IP地址不是合法的' for i in range(4): try: tmp = int(lists[i]) 阅读全文
摘要:
def foo(value): dict1 = {} a = 0 num =0 for i in range(len(value)): if value[i] in dict1: num = max(dict1[value[i]],num) a = max(i-num+1, a) dict1[val 阅读全文
摘要:
第一题: update CAR_RECORD set Car_Color = 'yellow' where Car_Num = "浙A12A26"; 第二题: select Rec_type as '违法类型',count(Rec_Type) as '数量' from CAR_DPRECORD gr 阅读全文