![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
heaven&earth
这一天天的,还不坚持
展开
-
插入不重复的数据
import requests as rfrom bs4 import BeautifulSoupimport pymysql as pqurl='https://www.shanghairanking.cn/rankings/bcur/202011'req=r.get(url)req.encoding=req.apparent_encodingbs=BeautifulSoup(req.text,'html.parser')datalist=bs.select('.rk-table t.原创 2020-12-12 23:10:42 · 227 阅读 · 0 评论 -
搜集整理随机产生人的姓名的2种方法
方法一:import randomdef 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 stdef first_name()原创 2020-12-12 23:05:03 · 1612 阅读 · 0 评论 -
on duplicate key update
import pymysql as pqfrom random_PersonName2 import random_nameimport datetimetry: print('连接到mysql服务器...') conn = pq.connect( host='127.0.0.1', port=3306, user='root', passwd='123456', db='examples', ...原创 2020-12-12 23:02:12 · 141 阅读 · 0 评论 -
mysql sql语句大全[留着学习用]
1、说明:创建数据库CREATEDATABASEdatabase-name2、说明:删除数据库dropdatabasedbname3、说明:备份sql server--- 创建 备份数据的 deviceUSE masterEXECsp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'--- 开始 备份BACKUP DATABASEpubs TOte...转载 2020-12-12 22:58:19 · 141 阅读 · 0 评论