python爬取音乐后写入数据库的易错点

384 阅读1分钟

1.往数据库的表添加值(sf和sdf用"sf"这种形式,用'sf'会报错)

insert_data ='insert ignore into music values (0,"sf","sdf")'
result = cur.execute(insert_data)

2.创建表格:记得加""",不然会报错

    create_table ="""create table music2 (
    ID INT ,   
    music_name varchar(20),
    music_url varchar(280),
    primary key (music_name)
    )
    """
    print(create_table)
    result = cur.execute(create_table)

3.传递参数

错误的写法

a = "12d"
b = "psk"
insert_data ="insert ignore into music values (0,a,b)
result = cur.execute(insert_data)

正确的写法

a = "12d"
b = "psk"
insert_data ="insert ignore into music values (0,'%s','%s')"%(a,b)
result = cur.execute(insert_data)