Does SQL 'Insert Into' save the new data?

Question

I am working through the lessons and it hasn't said anything about creating the tables, saving new data, or deleting data.
If I follow the 'INSERT INTO' instructions from the lesson, will it save the inserted values to the table when I'm done?
It seems like such a simple question but I have nowhere to test these lessons yet so I'm asking here. I appreciate everyone's answers and advice. Thank you. 😊

Answer 1

yes , it will make changes to the table ☺

Answer 2

>> …but I have nowhere to test these lessons…

There are online SQL sandboxes like this one:

http://sqlfiddle.com

Or you may set up your own SQL server on your local computer, if you are serious about learning it.

Answer 3

Thank you Marvin. This http://sqlfiddle.com works on my mobile browser. And yes friends, I am aware writing code, testing, and building a portfolio may be easier on an actual computer but for now I find it more convenient to study on my smartphone.

Answer 4

It will insert new row to the table and it will save the given data to that row.

After ”INSERT INTO” you specify your table name and after that you will give the data you want to save.

INSERT INTO table_name VALUES (”name”, ”age”)

You can use that if you are adding values for all the columns of the table.
Else you need to specify columns name after table name