weixin_51020254的博客

python操作mysql数据库import pymysql#db = MySQLdb.connect("127.0.0.1","root","123456","test" )dbpymysql.connect(host='127.0.0.1',user='root',password='123456',port= 3306)curror = db.cursor()#使用cursor()方法获取操作游标curror.execute('SELECT VERSION()')# 使用execute方

mysql 的指令 这是我的笔记 show databases;drop show databases;database python;create database pythonew charset=utf8;use mysql;select database(); show tables; create table xxxx(id int, name varchar(30));create table yyyy(id int primary key not null auto_incr