每日日报2021.11.1
完成内容:
1.学习python mysql数据库
1.连接
import mysql.connector
mydb = mysql.connector.connect( host="localhost", # 数据库主机地址 user="yourusername", # 数据库用户名 passwd="yourpassword" # 数据库密码 )
print(mydb)
2.创建数据库
import mysql.connector
mydb = mysql.connector.connect( host="localhost", user="root", passwd="123456" )
mycursor = mydb.cursor() mycursor.execute("CREATE DATABASE runoob_db")
3.查询数据库是否存在
import mysql.connector
mydb = mysql.connector.connect( host="localhost", user="root", passwd="123456" )
mycursor = mydb.cursor() mycursor.execute("SHOW DATABASES") for x in mycursor: print(x)
4.方法2
import mysql.connector
mydb = mysql.connector.connect( host="localhost", user="root", passwd="123456", database="runoob_db" )
遇到问题:
无
目标:继续学习python