CREATE - Part II
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.
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?
Everything was clear?
Thanks for your feedback!
Sectionย 4. Chapterย 5
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 2.22
CREATE - Part II
Swipe to show menu
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.
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?
Everything was clear?
Thanks for your feedback!
Sectionย 4. Chapterย 5