摘要:
# coding: utf-8 import smtplib from email.mime.text import MIMEText from email.header import Header # 发信方的信息:发信邮箱,QQ邮箱授权码 class QQemail: def __init__( 阅读全文
摘要:
# Definition for singly-linked list. class Node(object): def __init__(self, val=0, next=None): self.val = val self.next = next class Solution: def add 阅读全文
摘要:
select regexp_replace('50.8九 ,c...o【.。。。】。。。$##mmmmQWER@@*&^ 112 历史088天空','([^\\u4E00-\\u9FA5a-zA-Z0-9.]+)','') as name 阅读全文
摘要:
select phone,CONCAT_WS(',',collect_set(column name)) from table where ***group by phone 阅读全文
摘要:
select concat(unix_timestamp(),cast(rand() * 100000000 as int)) 阅读全文
摘要:
SELECT cidnum1,count(*) as num from ( SELECT DISTINCT id,cidnum, (CASE WHEN 0<cidnum and cidnum<=1 THEN '1个公司' WHEN 1<cidnum and cidnum<=5 THEN '2-5个公 阅读全文
摘要:
1、查询不含某个属性的节点 MATCH (n) WHERE NOT EXISTS(n.foo) RETURN n 2、 参考: 1、官方demo 阅读全文
摘要:
from aes_util import AesEncry import ast from efdir import fs import inspect def get_function_def_names(mod): fp = inspect.getabsfile(mod) code = fs.r 阅读全文
摘要:
mysql -h {host} -u {user} --password={password} {database} -e "SELECT concat_ws(',',human_pid,human_name,'human','person') as 'humanId:ID(Human-ID),na 阅读全文
摘要:
由于pandas版本0.24.0,数据类型: data['id']=data['id'].astype('Int64') 阅读全文