mysql
heaven&earth
这一天天的,还不坚持
展开
-
插入不重复的数据
import requests as r from bs4 import BeautifulSoup import pymysql as pq url='https://www.shanghairanking.cn/rankings/bcur/202011' req=r.get(url) req.encoding=req.apparent_encoding bs=BeautifulSoup(req.text,'html.parser') datalist=bs.select('.rk-table t.原创 2020-12-12 23:10:42 · 254 阅读 · 0 评论 -
搜集整理随机产生人的姓名的2种方法
方法一: import random def GBK2312(): head = random.randint(0xb0, 0xf7) body = random.randint(0xa1, 0xf9) # 在head区号为55的那一块最后5个汉字是乱码,为了方便缩减下范围 val = f'{head:x}{body:x}' st = bytes.fromhex(val).decode('gb2312') return st def first_name()原创 2020-12-12 23:05:03 · 1643 阅读 · 0 评论 -
on duplicate key update
import pymysql as pq from random_PersonName2 import random_name import datetime try: print('连接到mysql服务器...') conn = pq.connect( host='127.0.0.1', port=3306, user='root', passwd='123456', db='examples', ...原创 2020-12-12 23:02:12 · 147 阅读 · 0 评论 -
mysql sql语句大全[留着学习用]
1、说明:创建数据库 CREATEDATABASEdatabase-name 2、说明:删除数据库 dropdatabasedbname 3、说明:备份sql server --- 创建 备份数据的 device USE master EXECsp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat' --- 开始 备份 BACKUP DATABASEpubs TOte...转载 2020-12-12 22:58:19 · 148 阅读 · 0 评论