import pymysql
db = pymysql.connect('localhost', 'root', '123456', 'test_db')
cursor = db.cursor()
sql = """
CREATE TABLE books (
id int(8) NOT NULL AUTO_INCREMENT,
name varchar(50) NOT NULL,
category varchar(50) NOT NULL,
price decimal(10, 2) DEFAULT NULL,
publish_time date DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
"""
cursor.execute(sql)
cursor.execute('SHOW COLUMNS FROM books')
data = cursor.fetchall()
print(data)
db.close()
"""
(('id', 'int(8)', 'NO', 'PRI', None, 'auto_increment'), ('name', 'varchar(50)', 'NO', '', None, ''), ('category', 'varchar(50)', 'NO', '', None, ''), ('price', 'decimal(10,2)', 'YES', '', None, ''), ('publish_time', 'date', 'YES', '', None, ''))
"""