pymysql创建表

#创建表
import pprint
import pymysql


host = 'localhost'
user = 'test'
password = 'test'

connect = pymysql.connect(host, user, password)
cursor = connect.cursor()

create_database = '''
create database if not exists test;
'''
cursor.execute(create_database)
check_databases = '''
show databases;
'''
cursor.execute(check_databases)
pprint.pprint(cursor.fetchall())
use_test = '''
use test;
'''
cursor.execute(use_test)
create_table = '''
create table if not exists users(
    id int not null auto_increment,
    name varchar(45) null,
    age int null,
    primary key (id))default character set = utf8;
'''
cursor.execute(create_table)
#查询新创建的表的结构
cursor.execute('desc users')
result2 = cursor.fetchall()
print('-----------------')
pprint.pprint(result2)
cursor.close()
connect.close()