SQL Tutorial | Learn How to Insert Data into Tables
👉🏻 Sign up for Our Complete Data Science Training with 57% OFF: https://bit.ly/3kpCSIX
This SQL tutorial will help you learn how to INSERT data into tables.
For the purposes of this tutorial, we have re-organized a database script in an SQL file that you can download and run (https://www.dropbox.com/sh/ydl7k4286i.... Please, access the link available. Download the database file named “employees.sql”. As you scroll down, you’ll see the code that will create your entire database. Run the file and wait for a while. Once the execution phase is over, we can refresh the data in our schemas section. The “Employees” database will appear on our list.
Let’s practice inserting a few records in the “Employees” table. We can extract 10 records from the “Employees” table to see how the information is organized there. Please allow me to make the following remark: we increased the limit of rows displayed in an output to infinity. So, in the queries in this lecture, I will place limits through the LIMIT clause. Great!
We retrieved 10 rows, all containing information in the following columns: “employee number”,
“birth date”, “first” and “last name”, “gender”, and “hire date”. A total of six columns. Ok. Let’s see how we create a record in the “Employees” table. After the keyword phrase INSERT INTO, we must
specify the name of the table where we want to add information. Then, within parentheses, we must indicate the column names where data will be inserted. Please pay attention – you don’t have to use the names of all six columns! You can designate only those in which you would like to insert data. What follows is intuitive – the VALUES keyword, succeeded by the same number of data values as the number of columns indicated in the parentheses after the INSERT INTO statement.
► Consider hitting the SUBSCRIBE button if you LIKE the content: https://www.youtube.com/c/365DataScie...
► VISIT our website: https://bit.ly/365ds
🤝 Connect with us LinkedIn: / 365datascience
365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowledge and experience. We have prepared numerous courses that suit the needs of aspiring BI analysts, Data analysts and Data scientists.
We at 365 Data Science are committed educators who believe that curiosity should not be hindered by inability to access good learning resources. This is why we focus all our efforts on creating high-quality educational content which anyone can access online.
Check out our Data Science Career guides: • How to Become a... (Data and AI Caree...
#SQL #DataScience #MySQL
