SQL: Write Commands

Once we create a table, it’s empty. Let’s fill it with data. In this lesson, we’ll learn how to modify the database contents.

Insert record

To insert a record into a table, we need to specify which fields we provide and in which order. We use an INSERT INTO command with a tuple of field names followed by tuples with record values. We can insert multiple records in a single command, for example: