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.
Stay tuned! Bonus features for this video are under development...
In this Introduction to SQL Course, you will learn the essential queries needed to work with a relational database: How to create data (INSERT), change existing data (UPDATE), and find data (SELECT and JOINs). You will also learn how to choose a database, install PostgreSQL, speed up queries with indexes, and more.