How to implement the idea of ​​implementing an sql query?

Question

Python

There is a request like this:

self.cursor.execute('''INSERT INTO items (res_id, log_id, link, title, content, n_date, nd_date, s_date, not_date)
                       VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)''',
                       ( res_id,
                         log_id,
                         str(resource_link),
                         str(item_title),
                         str(item_content),
                         str(n_date),
                         nd_date,
                         s_date,
                         not_date
                       )
                                )

How can I make this query add news not one news at a time, but 100 news at a time?

Answer 1

Look in the documentation for your library how to do batch / bulk / multiple insert...