python：MySQL-python 增删改查_python增删改查技术

链接数据库

import mysql.connector

mydb = mysql.connector.connect(
    host="localhost",  # 数据库主机地址
    user="root",  # 数据库用户名
    passwd="yel219"  # 数据库密码
)

print(mydb)
1
2
3
4
5
6
7
8
9

python：MySQL-python 增删改查

# -*- coding:utf-8 -*-
# /usr/bin/python
'''
@Author:  Yan Errol  
@Email:2681506@gmail.com   
@Date:  2019-05-31  11:38
@File：mysql_class.py
@Describe:链接mysql
@ Env
pip install ConfigParser
pip install MySQL-python
'''


import mysql.connector


class Mysql_Connector():

    mydb = mysql.connector.connect(host="localhost",user="root",passwd="yel219")
    mydb2 = mysql.connector.connect(host="localhost", user="root", passwd="yel219",database='yanerrol')

    def query_database(sel
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22