Uploaded March 2019 | Updated September 2026, 2 weeks ago

---

The INSERT INTO SQL statement is used to add data to a database. You can add one or more rows to a table in a single query. These two approaches are similar in appearance but very different in speed. We will also write a Python program to insert 20,000 rows into a database using two different INSERT INTO techniques, and see which one is faster.

Our SQL playlist starts here:
↪bit.ly/Socratica_SQL

Be sure to SUBSCRIBE for more SQL!
↪ bit.ly/SocraticaSubscribe

You may also enjoy our Python playlist:
↪bit.ly/PythonSocratica

♦♦♦♦♦♦♦♦♦♦

Ways to support our channel:

►  Join our Patreon : patreon.com/socratica
►  Make a one-time PayPal donation: paypal.me/socratica
►  We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9

Thank you!

♦♦♦♦♦♦♦♦♦♦

Connect with us!

Facebook: facebook.com/SocraticaStudios
Instagram: instagram.com/SocraticaStudios
Twitter: twitter.com/Socratica

♦♦♦♦♦♦♦♦♦♦

SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter)
Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496)

♦♦♦♦♦♦♦♦♦♦