How to insert data into your Table, the correct way
After your table is already created, you can add multiple kind of information..
Let’s start
You can now start adding data into it with the INSERT INTO command:
- Inserting a single record:
INSERT INTO people VALUES (20, 'Tony');- Inserting multiple records:
INSERT INTO people VALUES (57, 'Joe'), (8, 'Ruby');
- Inserting data into specific columns:
INSERT INTO people (name) VALUES ('Harry');To execute these queries using TablePlus SQL editor, follow these steps:
- Open TablePlus and connect to your database.
- In the SQL editor, paste one of the provided queries.
- Select the query with your mouse.
- Click on “Run Current” to execute the query.
After executing the queries, you can refresh the database view, click on the “people” table, and inspect its content. You’ll see the inserted data reflecting the changes made.
Conclusion
These INSERT INTO commands allow you to populate your database tables with the necessary data, providing a foundation for meaningful interactions and queries. Feel free to experiment with different values and combinations to familiarize yourself with the process of inserting data into a SQL database.
After your table is already created, you can add multiple kind of information..
Let’s start
You can now start adding data into it with the INSERT INTO command:
- Inserting a single record:
INSERT INTO people VALUES (20, 'Tony');- Inserting multiple records:
INSERT INTO people VALUES (57, 'Joe'), (8, 'Ruby');
- Inserting data into specific columns:
INSERT INTO people (name) VALUES ('Harry');To execute these queries using TablePlus SQL editor, follow these steps:
- Open TablePlus and connect to your database.
- In the SQL editor, paste one of the provided queries.
- Select the query with your mouse.
- Click on “Run Current” to execute the query.
After executing the queries, you can refresh the database view, click on the “people” table, and inspect its content. You’ll see the inserted data reflecting the changes made.
Conclusion
These INSERT INTO commands allow you to populate your database tables with the necessary data, providing a foundation for meaningful interactions and queries. Feel free to experiment with different values and combinations to familiarize yourself with the process of inserting data into a SQL database.
It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using ‘Content here, content here’, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for ‘lorem ipsum’ will uncover many web sites still in their infancy.
It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using ‘Content here, content here’, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for ‘lorem ipsum’ will uncover many web sites still in their infancy.
The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using ‘Content here, content here’, making
The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using ‘Content here, content here’, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for ‘lorem ipsum’ will uncover many web sites still in their infancy.
