0

【数据库】听故事的故事人

 2 years ago
source link: https://blog.feelyou.top/posts/2329761363.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

【数据库】听故事的故事人

2019-01-13

11

-- 注：语句为python执行语句
-- 创建菜单数据库
CREATE TABLE music_dic (music_id real, music_name text, time text);

-- 菜单信息，有则更新，无则插入
REPLACE INTO music_dic VALUES(?,?,?);

-- 新建评论数据库
CREATE TABLE IF NOT EXISTS music + str(music_id) + (music_name text, comment_id real ,user_id text,user_name text,avatar_url text,comment_time real,liked_count real,comment text);

-- 插入爬虫数据
INSERT INTO music"+str(music_id)+" VALUES(?,?,?,?,?,?,?,?);

最后更新时间：2021-04-22 19:41:40
转载请注明来源：http://blog.feelyou.top/posts/2329761363.html


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK