mysql in docker

下载image：

docker pull mysql:5.7.14

后台启动image：

docker run --name mysql -v /Users/SakuraTheBest/Documents/mysql/data:/var/lib/mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root  -d mysql:5.7.14

import pymysql


class conDB():
    def __init__(self):
        self.db = pymysql.connect(
            host="localhost", user="root", password="root", database="mysql", charset="utf8")
        self.cursor = self.db.cursor()
        print("self connect db")

    def __del__(self):
        try:
            self.cursor.close()
            print('close cursor')
        except:
            pass
        try:
            self.db.close()
            print('close db')
        except:
            pass

    def createTable(self):
        # ----create table----
        # create_sql = 'create table BSakura( id int(32) auto_increment not null primary key, name varchar(256) not null, data text);'
        # self.cursor.execute(create_sql)
        # -----execute many---
        print('use database mysql to create data')
        insert_sql = 'insert into BSakura(name,data) values (%s,%s);'
        # increment id also will increase when this sql failed
        rows = self.cursor.executemany(insert_sql,[("sakura","bed"),("sakura","sunny"),])
        self.db.commit()
        return rows


if __name__ == '__main__':
    conDB = conDB()
    createTable = conDB.createTable()

解决失败自增：https://www.cnblogs.com/zdz8207/p/3511147.html
展示所有容器ip

docker inspect --format='{{.Name}} - {{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' $(docker ps -aq)