Tag:djangopythonmysqllinuxphp
Article From:https://segmentfault.com/q/1010000012144099
Question:

After collecting data with scrapy.
Inserting the database table directly with the SQL statement

The database table for dedecms is now as follows:
The content of the article is in the body of dede_addonarticle

Another part is the title column and so on in Title typeID PubDate of dede_archives.

How do I write to insert the statements of these two database tables dede_addonarticle dede_archives?

Answer 0:
INSERT INTO dede_addonarticle VALUES (12345,3,"This is the content","http://url.com","xxx","yyy")

Spell it slowly, and recommend the str.format statement.

Leave a Reply

Your email address will not be published. Required fields are marked *