Summary  
This chapter covers using the INSERT INTO statement to add rows to a table, defining a primary key column, and applying the AUTO_INCREMENT attribute to generate unique integer IDs automatically.

General domain of usage  
Database management

### Important Points:
- The general syntax of the **INSERT statement** is `INSERT INTO table_name (column1, column2, …) VALUES (value1, value2, …)`;
- We can use the `PRIMARY KEY` keyword to convert a column into a primary key;
- The `AUTO_INCREMENT` keyword is used to make a column automatically assign incremented values to new rows. This can only be applied to columns that are INT or INT-based data types.


Which of the following are correct for creating a table with a primary key which auto increments?

What is the correct syntax for inserting new rows into an existing table?

This course will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

This module will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

CREATE - Part II

Important Points:

1. Which of the following are correct for creating a table with a primary key which auto increments?

2. What is the correct syntax for inserting new rows into an existing table?