创建连接

conn = pymysql.connect(host='localhost',user='root',password='Cdsf@119', database='knowledge_base')

创建游标

cursor = conn.cursor()

创建数据库的sql(如果数据库存在就不创建，防止异常)

sql = "CREATE DATABASE IF NOT EXISTS knowledge_base"

执行创建数据库的sql

cursor.execute(sql)

创建表

sql_2 = '''CREATE TABLE file_doc ( id INT(10) NOT NULL AUTO_INCREMENT, kb_name VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', file_name VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', doc_id VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', meta_data JSON NULL DEFAULT NULL, PRIMARY KEY (id) USING BTREE ) COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=4030 ; ''' cursor.execute(sql_2)

sql_3 = """CREATE TABLE knowledge_base ( id INT(10) NOT NULL AUTO_INCREMENT, kb_name VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', kb_info VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', vs_type VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', embed_model VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci', file_count INT(10) NULL DEFAULT NULL, create_time TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (id) USING BTREE ) COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=208 ;"""

cursor.execute(sql_3)