you are at Encyclopedia of SQL >> INSERT INTO
INSERT INTO
With INSERT INTO we can add new record into table
Syntax
INSERT INTO `table_name`
VALUES ('value','value2')
Syntax for adding new records into specified columns
INSERT INTO `table_name` (`column_name1`,`column_name2`)
VALUES ('value','value2')
Example
Add new record with name Jan and surname Kowalski into `people` table
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
INSERT INTO `people` (`name`,`surname`)
VALUES ('value','value2')
result
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
| Jan | Kowalski | NULL |
[ wróć na górę strony ]
