Main content
Course: Unlisted resources area > Unit 2
Lesson 3: SQL documentation- SQL: CREATE table with multiple data types
- SQL: CREATE table with a primary key
- SQL: Specifying DEFAULT values in CREATE TABLE
- SQL: CREATE TABLE with foreign key reference
- SQL: INSERTing values in tables
- SQL: SELECTing rows
- SQL: SELECTing with WHERE conditions
- SQL: Filter with IN
- SQL: SELECT with ORDER BY
- SQL: Transform SELECT results with CASE
- SQL: Filtering with LIKE
- SQL: Using SELECT with LIMIT
- SQL: ROUND and other core functions
- SQL: SELECT with aggregate functions
- SQL: Grouping SELECT results with GROUP BY
- SQL: Using HAVING with GROUP BY
- SQL: JOIN on tables
- SQL: UPDATE and DELETE
- SQL: ALTER TABLE
© 2024 Khan AcademyTerms of usePrivacy PolicyCookie Notice
SQL: INSERTing values in tables
Use
INSERT
to insert rows into a table. You can either specify every column value in parentheses after the VALUES
keyword, or you can specify a comma-separated list of columns name before VALUES
, and only specify those column values in the parentheses after.If you don't specify the value for a column that's the primary key, then the SQL engine will fill it in automatically with a unique id. If you don't specify the value for other columns, then SQL will fill them in with either
NULL
or their default value, if one was specified.▶️ You can also learn about this in our Creating a table and inserting data talkthrough.