📝 SQL INSERT Queries
The INSERT
statement adds new records to a table. You specify the table name, the columns, and the values you want to add.
📖 Example: Add a New User
Query result will appear here...
📌 INSERT Syntax
INSERT INTO
— Specifies the table to insert data into.
- Column names are listed in parentheses.
VALUES
— Provides the corresponding values for each column.
- String values are enclosed in single quotes
' '
.
- Always end your statement with a semicolon
;
.
💡 Tip: You can omit the column list if you're providing values for all columns in order, but it's safer to always be explicit.