create table urls (
id int not null auto_increment,
url varchar(1000) not null,
content varchar(4000) not null,
created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
primary key(id)
);
最后呢在pycharm中就可插入数据了, 下面是我的案例, 与建表代码相对应
import MySQLdb
conn = MySQLdb.connect(host='localhost', user='root', passwd='373617', db='test')
cur = conn.cursor()
cur.execute("INSERT INTO urls (url, content) VALUES ('www.baidu.com', 'This is content.')")
cur.close()
conn.commit()
conn.close()