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

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)
复制代码

转载于:https://juejin.im/post/5ca9ea036fb9a05e472b9c3d