# 进程：正在进行的一个过程或者一个任务 # multiprocessing模块:用来开启子进程，并在子进程中执行任务 # 使用process类创建两个子进程 from multiprocessing import Process import os import...

1.创建数据库和数据表 import pymysql CREATE_SCHEMA_SQL = 'CREATE SCHEMA bank' CREATE_TABLE_SQL = '''CREATE TABLE account( account_id varchar(20) not null, account_passwd char(6) not...

import pymysql zwy = pymysql.connect(host='localhost', user='root', password='123456789', db='world') cursor = zwy.cursor() zwy.commit() delete_sql = 'delete from student where sna...

1 import socket host = socket.gethostname() port=8081 serversock=socket.socket(socket.AF_INET,socket.SOCK_STREAM) serversock.bind((host,port)) serversock.listen(5) print('等待客户...

import pymysql db = pymysql.connect( host='localhost', user='root', password='123456789', db='world' ) cursor = db.cursor() sql = '''CREATE TABLE zhangsan ( sno CHAR(10) PRIMARY KE...

import pymysql # 建立数据库连接 db = pymysql.connect(host='localhost', user='root', password='123456', db='stu') cursor = db.cursor() # 创建学生表的SQL语句（注释掉了，因为表如果已...

 

import pymysql zwy = pymysql.connect(host='localhost', user='root', password='123456789', db='world') cursor = zwy.cursor() insert_many_sql = [('01', 'zwy', 'n'), ('02', 'yxj', 'n'...

import pymysql zwy = pymysql.connect(host='localhost', user='root', password='123456789', db='world') cursor = zwy.cursor() create_sql = '''create table student ( sid char(10), sna...