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?
Was alles duidelijk?
Bedankt voor je feedback!
Sectie 4. Hoofdstuk 5
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.