mysql 使用
启动服务
sudo systemctl start mysql
pip3 install pymysql
python 操作数据库:
- 定义类
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
import pymysql
class MyDb():
def __init__( self , host, user, passwd, db):
self .__db = pymysql.connect(host, user, passwd, db)
self .__cursor = self .__db.cursor()
# 增删改-数据库
def set ( self , sql):
try :
self .__cursor.execute(sql)
self .__db.commit()
except Exception as e:
self .__db.rollback()
print ( 'Execute Error: \n {e}' )
# 查-数据库
def get( self , sql, fetchone = True ):
self .__cursor.execute(sql)
try :
if fetchone = = True :
data = self .__cursor.fetchone()
else :
data = self .__cursor.fetchall()
except Exception as e:
print ( 'Execute Error: \n {e}' )
data = None
finally :
return data
# 关闭数据库
def close( self ):
self .__db.close()
|
- 调用
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
def example():
## 实例化数据库
### 类参数:host、user、passwd、db
db = MyDb( 'localhost' , 'root' , 'zuoy123' , 'test' )
## 查看版本
get_version_sql = 'SELECT VERSION()'
version = db.get(get_version_sql)
print (f 'Database Version: {version}' )
## 删除表
delete_table_sql = 'DROP TABLE IF EXISTS employee'
db. set (delete_table_sql)
## 新建表
new_table_sql = 'CREATE TABLE IF NOT EXISTS employee( \
id INT NOT NULL PRIMARY KEY, \
name CHAR( 21 ) NOT NULL, \
age DOUBLE DEFAULT 18 )'
db. set (new_table_sql)
## 查找表
get_table_sql = 'SHOW TABLES'
data = db.get(get_table_sql)
if data:
print (data)
## 关闭数据库
db.close()
if __name__ = = '__main__' :
example()
|
常用sql
1
2
|
DROP TABLE IF EXISTS employee;
CREATE TABLE IF NOT EXISTS employee(id INT );
|
以上就是python操作 mysql的步骤的详细内容,更多关于python操作 mysql的资料请关注服务器之家其它相关文章!
原文链接:https://cloud.tencent.com/developer/article/1526845