PYTHON在mysql中新建数据库

import pandas as pd
import pymysql as ps

conn=ps.connect(host='localhost',port=3306,user='root',password='root@123',db='stock',charset='utf8')
cursor = conn.cursor()

sql='create table stock_new (state_dt varchar(45), stock_code  varchar(45),open decimal(20,2),close decimal(20,2),high decimal(20,2),low decimal(20,2),vol int(20),amount decimal(30,2),pre_close decimal(20,2),amt_change decimal(20,2),pct_change decimal(20,2) , primary key(state_dt,stock_code));'

cursor.execute(sql)

conn.commit()

cursor.close()

conn.close()