SQL: Write Commands

Learn how to write CRUD commands in SQL.

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:

Get hands-on with 1200+ tech skills courses.