pymysql读取mysql表单_pymysql操作mysql

pymysql操作mysql

安装,启动及链接

MySQL

安装mysql:

sudo apt-get install -y mysql-server mysql-client

启动、关闭和重启MySQL服务:

sudo service mysql start

sudo service mysql stop

sudo service mysql restart

sudo service mysql status:查看状态

netstat -an|grep 3306:查看mysql是否启动成功,监听3306端口

pymysql

安装pymysql:

pip3 install pymysql

链接数据库

链接之前,要启动mysql

import pymysql # 1.导入pymysql包

db = pymysql.connect(host='localhost', user='root',

password='123456',port=3306) # 2.声明一个MySQL连接对象db,在远程host传入其公网ip

cursor =db.cursor() # 3.获得操作游标

cursor.execute('SELECT VERSION()') # 4.通过游标进行操作,execute()执行sql语句

data = cursor.fetchone() # 获得第一条数据

print('Database version:', data)

cursor.execute("CREATE DATABASE spiders DEFAULT CHARACTER