python21 利用PyMySql对数据库交互
1. 为什么要和数据库进行交互?
我认为,在对产品设计开发流程中的增删改查乃至于从数据库调取数据都离不开数据库的帮助。在中小型产品的开发当中,譬如很多时候我们也可以利用后端把一些如天气,温度这种即时数据(real-time data)载入数据库中,这种时候,我们要调取也需要脚本访问数据库。
2. PyMySql库环境与安装
安装方式如下👇:
$ python3 -m pip install PyMySQL
pymsql的目前所需环境是:
Python – one of the following:
CPython >= 2.7 or >= 3.5
Latest PyPy
MySQL Server – one of the following:
MySQL >= 5.5
MariaDB >= 5.5
3. 使用示例
CRUD(增删改查)
The following examples make use of a simple table
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(255) COLLATE utf8_bin NOT NULL,
`password` varchar(255) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
AUTO_INCREMENT=1 ;
import pymysql.cursors
# Connect to the database
connection = pymysql.connect(host='localhost',
user='user',
password='passwd',
db='db',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
try:
with connection.cursor() as cursor:
# Create a new record
sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"
cursor.execute(sql, ('[email protected]', 'very-secret'))
# connection is not autocommit by default. So you must commit to save
# your changes.
connection.commit()
with connection.cursor() as cursor:
# Read a single record
sql = "SELECT `id`, `password` FROM `users` WHERE `email`=%s"
cursor.execute(sql, ('[email protected]',))
result = cursor.fetchone()
print(result)
finally:
connection.close()
This example will print:
{'password': 'very-secret', 'id': 1}
4. 总结
这套框架是利用一个在数据库里建立cursor然后进行抓取信息。在插入数据的时候也是插入一个个tuple。
打赏二维码👉👉👉: 欢迎看官扫描二维码请博主喝一杯咖啡
本作品采用 知识共享署名-相同方式共享 4.0 国际许可协议 进行许可。
[url=https://erectionclub.us]roman viagra cost south africa[/url]
cialis patent expiration
[url=https://erectionclub.us]cialis brand 10mg[/url]
[url=https://cymbalta2021.us]warnings for cymbalta[/url]
cymbalta pupil
[url=https://cymbalta2021.biz]cymbalta cost a pill[/url]
cymbalta cost walmart
[url=https://cephalexin2021.us]cat antibiotics cephalexin 10mgs[/url]
cephalexin and ear clogginh
[url=https://cephalexin2021.biz]ancef and keflex[/url]
does keflex interact with nexplanton
free personal ads online
[url="http://datingfreetns.com/?"]dating websites [/url]
[url=https://celebrex2021.us]celebrex and diarrhea[/url]
celecoxib manufacturer coupon
[url=https://celebrex2021.biz]warnings for celebrex[/url]
celebrex 100mg capsules
[url=https://azithromycin2021.us]azithromycin side effects[/url]
azithromycin
[url=https://amoxicillin2021.us]amoxicillin for syphilis[/url]
does amoxicillin cause constipation
[url=https://amoxicillin2021.biz]can i drink alcohol on amoxicillin[/url]
amoxicillin is used for what
[url=https://veryhard.us]cheap generic cialis free shipping[/url]
sildenafil 50mg buy
[url=https://veryhard.us]buy viagra online with mastercard[/url]
[url=https://superhard.us]levitra 20mg how to use australia[/url]
cialis 40mg generic
[url=https://superhard.us]generic viagra pictures south africa[/url]
[url=https://megahard.us]30 mg sildenafil[/url]
sildenafil otc uk
[url=https://megahard.us]fake cialis 20mg australia[/url]
[url=https://erection365.us]low cost tablet ordering viagra[/url]
cialis gel france
[url=https://erection365.us]cialis not working first time australia[/url]
[url=https://erection24h.us]sildenafil oral gel youtube[/url]
purchase viagra uk
[url=https://erection24h.us]online cialis next day[/url]
[url=https://erectionclub.us]cialis online paypal accepted[/url]
cialis 20mg cost walmart
[url=https://erectionclub.us]how much is 1 viagra pill[/url]
[url=https://thesisacloud.com/]thesisacloud.com[/url] thesis service thesisacloud.com law thesis
[url=https://thesiswritingtob.com/]help in writing thesis[/url] free thesis help psychology thesis writing my thesis
[url=https://thesisacloud.com/]thesis literature review[/url] writing a thesis paper thesis assistance writing thesis express
[url=https://ljcialishe.com/]viagra vs cialis hardness[/url] [url=https://cialisvja.com/]can i take 40mg of cialis[/url] [url=https://viagraonlinejc.com/]strongest viagra pill[/url] [url=https://viagratx.com/]generic viagra online for sale[/url] [url=https://buycialisxz.com/]cialis 20 mg price costco[/url]
python21 利用PyMySql对数据库交互 - 井理
[url=http://www.go1o2k7y1pkxk774604a1q8xy7vr79q5s.org/]uehomttnngk[/url]
aehomttnngk
ehomttnngk http://www.go1o2k7y1pkxk774604a1q8xy7vr79q5s.org/
[url=https://thesisacloud.com/]help writing thesis[/url] best thesis editing services free thesis help online thesis writing
python21 利用PyMySql对数据库交互 - 井理
jmthjoegyg http://www.g5dd1okx53x366e0og67i25b479auo8js.org/
[url=http://www.g5dd1okx53x366e0og67i25b479auo8js.org/]ujmthjoegyg[/url]
ajmthjoegyg
[url=https://dissertationahelp.com/]uk dissertation help[/url] dissertation editors dissertation editing service dissertation writing services uk
[url=https://thesisacloud.com/]help with thesis[/url] writing a thesis paragraph psychology thesis topics writing with a thesis
[url=https://kloviagrli.com/]cheap viagra[/url] [url=https://vigedon.com/]buy viagra online without prescriptions[/url] [url=https://llecialisjaw.com/]what cialis[/url] [url=https://jwcialislrt.com/]cialis coupons[/url] [url=https://jecialisbn.com/]cialis 20 mg price[/url]
[url=https://essaywritera.com/]which is the best essay writing service[/url] online essay editing service service essays which essay writing service is the best
[url=http://essaywriteris.com/]buy essays online cheap[/url] can t write my essay buy essay online for cheap the best essay writer
[url=http://vsviagrav.com/]online pharmacy[/url]
cialis В® for daily use generic cialis reviews cialis tadalafil paypal
what color is viagra what is the shelf life of viagra viagra pills online
viagras 100mg best price viagra viagra for sale on line
can you buy generic viagra in canada http://vigedon.com/ cheap viagra in usa
cash loans warrnambool direct lenders only for payday loans payday loans 12 month repayment uk
buy cialis uk suppliers ingen effekt av cialis precio cialis tadalafil
free viagra and cialis samples how to get cialis 800mg cialis generic
direct payday loan lenders in colorado rocky mountain payday loans online payday loans canada no fax
payday loans online for savings account cash advance bossier pre approved cash loans
cialis in frankreich rezeptfrei pharmacie en ligne france cialis cialis flughafen
can i pay my ace cash express loan online payday loan arkansas 90 day payday loans approved bad credit
viagra alternatives australia viagra edmonton viagra how to buy without prescription
Viagra Oral Jelly legitimate online pharmacies erectile dysfunction medications
viagra buy canada where to get viagra in bangalore viagra for sale
compare prescription prices canada drug go coupon
viagra ireland online generic viagra 60 pills viagrapatent expiration date
online pharmacy no prescription needed canadian drugs online pharmacy trusted overseas pharmacies
ed meds online canadian pharmacies without prescriptions tadalafil
online pharmacy reviews where do i buy viagra in sydney online pharmacies in usa
pharmacy in canada best online pharmacies no prescription drugs from canada with prescription
how can i buy viagra online use paypal to buy viagra cheap viagra in us [url=http://genqpviag.com/]viagra canada[/url] ’
purchasing viagra onlime viagra tablets online viagras forsale [url=http://llviabest.com/]purchase viagra with paypal[/url] ’