2019 7.2学习笔记

navicat:

nacicat是一个操作Mysql数据库非常方便的软件。

pycharm连接Mysql数据库

import pymysql

conn=pymysql.connect(host='localhost',user='root',password='',database='pymysql_demo')
cursor=conn.cursor()
cursor.execute("select 1")
result=cursor.fetchone()
print(result)
conn.close()

pycharm插入数据到mysql的两种方式

import pymysql

conn=pymysql.connect(host='localhost',user='root',password='',database='pymysql_demo')
cursor=conn.cursor()

# sql="""
# insert into user(id,username,age,password) values(2,'bbb',18,'111111')
# """
# cursor.execute(sql)
# conn.commit()
sql="""
insert into user(id,username,age,password) values(null,%s,%s,%s)
"""
username='spider'
age=21
password='12345'
cursor.execute(sql,(username,age,password))
conn.commit()
conn.close()

 明天去杭州面试了 今天没学多少