INSERT INTO - Adding Records1 / 10
The INSERT INTO command is how you insert a new record into a database table. Try:
Yes, there are other ways to do this, but this method is best practice and is optimized for learning.
INSERT INTO cities (city_id, city_name, country, population_millions) VALUES (6, 'Lisbon', 'Portugal', 0.5);Yes, there are other ways to do this, but this method is best practice and is optimized for learning.
| city_id | city_name | country | population_millions |
|---|---|---|---|
| 1 | Paris | France | 2.1 |
| 2 | Berlin | Germany | 3.6 |
| 3 | Madrid | Spain | 3.2 |
| 4 | Rome | Italy | 2.8 |
| 5 | Vienna | Austria | 1.9 |
Ctrl+Enter to submit
INSERT INTO - Adding Records - Free SQL Practice Online
Practise INSERT INTO - Adding Records with 10 free, interactive SQL exercises. You type real queries into your browser and get instant feedback on every answer - no database setup, no install, and no signup. It is a fast, hands-on way to learn SQL online and build query skills you can use at work.