Which SQL command is used to add a new record to a table?

The SQL command used to add a new record to a table is the INSERT statement. This command is specifically designed to allow users to input one or more rows of data into a database table. The syntax typically follows the format of specifying the table name, followed by a list of columns and corresponding values for the new record.

For example, when you write an INSERT statement, you can clearly define the data you want to add, which makes it straightforward to use when populating a database with new information. In practice, this command is fundamental for database management because it enables data entry and updates for dynamic applications.

In contrast, other commands serve different purposes: UPDATE modifies existing records, CREATE is used to set up new tables or databases, and DELETE removes records from a table. Each command has its role in SQL, but for adding new entries, INSERT is the appropriate choice.