Populating a SQL Database Table with New Data

Learn how to use Structured Query Language (SQL) to insert new rows into a table with a set of given column values.

You can also use SQL to add new data to a table. The lecture goes over the insert statement so you can populate a table with new rows.

You first learn the implicit way, then you learn the explicit way that requires you specify every column name in the table.

Along the way you are also exposed to the UNIQUE constraint that can be set on a specific column to prevent duplicate rows with the same column value. Primary key columns usually have that unique constraint.