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 ]