mysql 建表 not null_MySQL中建表时可空（NULL）和非空（NOT NULL）的用法详解

#!/usr/bin/env python3

import pymysql

import time

mysql_conn_conf = {'host': '127.0.0.1', 'port': 3306, 'user': 'root', 'password': '******', 'db': 'db01'}

def mysql_read(table_name):

conn = pymysql.connect(host=mysql_conn_conf['host'], port=mysql_conn_conf['port'], database=mysql_conn_conf['db'],user=mysql_conn_conf['user'],password = mysql_conn_conf['password'])

cursor = conn.cursor()

try:

cursor.execute(''' select id,c2,c3 from {0} where id>3888888 and id<3889999;'''.format(table_name))

row = cursor.fetchall()

except pymysql.Error as e:

print("mysql execute error:", e)

cursor.close()

conn.close()

def mysql_write(loop,table_name):

conn = pymysql.connect(host=mysql_conn_conf['host'], port=mysql_conn_conf['port'], database=mysql_conn_conf['db'],user=mysql_conn_conf['user'],password = mysql_conn_conf['password'])

cursor = conn.cursor()

try:

if loop%10 == 0:

cursor.execute(''' insert into {0}} (c2,c3) values(DEFAULT,DEFAULT)'''.format(table_name))

else:

cursor.execute(''' insert into {1}} (c2,c3) values(uuid(),uuid())'''.format(table_name))

except pymysql.Error as e:

print("mysql execute error:", e)

cursor.close()

conn.commit()

conn.close()

if __name__ == '__main__':

time_start = time.time()

loop=10

while loop>0:

mysql_write(loop)

loop = loop-1

time_end = time.time()

time_c= time_end - time_start

print('time cost', time_c, 's')