pip install pymysql
#或者
pip3 install pymysql

pip list | grep PyMySQL 
#注意大小寫(xiě)

import pymysql

db = pymysql.connect(
    host="localhost", 
    port=3306,
    user='root',    #在這里輸入用戶名
    password='888888',     #在這里輸入密碼
    charset='utf8mb4' 
    ) #連接數(shù)據(jù)庫(kù)

cursor = db.cursor() #創(chuàng)建游標(biāo)對(duì)象

sql = 'show databases' #sql語(yǔ)句

cursor.execute(sql)  #執(zhí)行sql語(yǔ)句

one = cursor.fetchone()  #獲取一條數(shù)據(jù)
print('one:',one)

many = cursor.fetchmany(3) #獲取指定條數(shù)的數(shù)據(jù)，不寫(xiě)默認(rèn)為1
print('many:',many)

all = cursor.fetchall() #獲取全部數(shù)據(jù)
print('all:',all)

cursor.close()  
db.close()  #關(guān)閉數(shù)據(jù)庫(kù)的連接

import pymysql

db = pymysql.connect(
    host="localhost", 
    port=3306,
    user='root',    #在這里輸入用戶名
    password='888888',     #在這里輸入密碼
    charset='utf8mb4' 
    )

cursor = db.cursor() #創(chuàng)建游標(biāo)對(duì)象

try:

    sql = 'show databases' 
    cursor.execute(sql)
    print('未創(chuàng)建數(shù)據(jù)庫(kù)前：',cursor.fetchall()) #獲取創(chuàng)建數(shù)據(jù)庫(kù)前全部數(shù)據(jù)庫(kù)

    dbname = 'justtest'
    sql = 'create database if not exists %s'%(dbname) #創(chuàng)建數(shù)據(jù)庫(kù)
    cursor.execute(sql)
    sql = 'show databases' 
    cursor.execute(sql)
    print('創(chuàng)建新的數(shù)據(jù)庫(kù)后：',cursor.fetchall()) #獲取創(chuàng)建數(shù)據(jù)庫(kù)后全部數(shù)據(jù)庫(kù)

    sql = 'drop database if exists %s'%(dbname) #刪除數(shù)據(jù)庫(kù)
    cursor.execute(sql)
    sql = 'show databases' 
    cursor.execute(sql)
    print('刪除新的數(shù)據(jù)庫(kù)后：',cursor.fetchall()) #獲取刪除數(shù)據(jù)庫(kù)后全部數(shù)據(jù)庫(kù)

except Exception as e:
    print(e)
    db.rollback()  #回滾事務(wù)

finally:
    cursor.close() 
    db.close()  #關(guān)閉數(shù)據(jù)庫(kù)連接

import pymysql

db = pymysql.connect(
    host="localhost", 
    port=3306,
    user='root',    #在這里輸入用戶名
    password='888888',     #在這里輸入密碼
    charset='utf8mb4',
    database='justtest'     #指定操作的數(shù)據(jù)庫(kù)
    )

cursor = db.cursor() #創(chuàng)建游標(biāo)對(duì)象

try:

    tableName = 'user'
    sql = 'create table  %s (id varchar(20) not null, name varchar(20) not null, primary key(id))'%(tableName) 
    cursor.execute(sql)     #執(zhí)行sql語(yǔ)句，創(chuàng)建表

    sql = 'show tables'
    cursor.execute(sql)
    print('顯示創(chuàng)建的表:',cursor.fetchall())  #顯示創(chuàng)建的表


    sql = 'desc %s'%(tableName) 
    cursor.execute(sql)
    print('顯示表結(jié)構(gòu):',cursor.fetchall())  #顯示表結(jié)構(gòu)

except Exception as e:
    print(e)
    db.rollback()  #回滾事務(wù)

finally:
    cursor.close() 
    db.close()  #關(guān)閉數(shù)據(jù)庫(kù)連接