con = pymysql.connect(host='192.168.0.10', user='root', passwd='123456', db='living', port = 3306) # 连接
cur = con.cursor()sql_order = 'select * from p_table'
p_table_in = read_table(cur, sql_order)
sql_order = "select COLUMN_NAME from information_schema.COLUMNS where table_name = 'p_table' and table_schema = 'living' "
p_table_name=read_table(cur, sql_order)
con.commit()
cur.close()
con.close()