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

Prepare for the Leaving Certificate Computer Science Test with a mix of flashcards and multiple choice questions, each designed to enhance learning. Discover tips and resources for success. Ace your exam with confidence!

The SQL statement used to add a new record to a table is INSERT. This command is specifically designed to add data into a specified table in a database. When using the INSERT statement, you provide the name of the table and the values for each column that you want to populate with data.

For example, if you have a table called "Students" and you want to add a new student record, you would use an INSERT statement to specify the columns (like name, age, grade) and their corresponding values (like 'John Doe', 16, '10th Grade'). This effectively creates a new row in the "Students" table with the provided data.

The other commands serve different purposes: UPDATE modifies existing records, SELECT retrieves data from tables, and DELETE removes records from a table. Each SQL command has a distinct role, which is important to understand when managing a database.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy