mysql学习笔记（python3.6管理）

1，首先去官网下载mysql安装包，然后安装

2，装好之后配置环境变量，path指向bin目录下

3，进入cmd——>net start mysql57  启动数据库

net stop mysql57

net remove mysql57 这些命令就不解释了，看英文就懂

4，进入cmd——>mysql -u root -p 之后键入密码

5，mysql常见操作：

show databases;

creata database test;

drop database test; 删除test

use test;

create table book(id int auto_increment,name text,price int,primary key(id));  设置关键字和sqlite3不同

drop table book;

insert into book(name,price) values("mysql",55);

update book set name = "python",price = 53 where id = 1;

select * from book;

select name from book;

select book.price from book2;

delete from book2 where id = 1;

6，python3.6与mysql建立链接：

 （1），首先我们要安装pymysql : pip3.6 install pymysql

pip3.6 install mysql-connector-python（3之前可以直接装mysql)

（2），然后进入python操作

import pymysql
db = pymysql.connect(host='127.0.0.1',user='root',passwd='123456',db = 'test')
cur = db.cursor()
cur.execute("select * from book")
l = cur.fetchall()
cur.execute("update book set name = "c++ primer",price=99 where id = 1")
cur.commit()
cur.close()
db.close()