Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How to Insert Into Table In SQL. That video is uploaded by Internet Services and Social Networks Tutorials from HowTech at 2013-05-29T15:00:42-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [6WMvVwqJpN4]
| Name | How to Insert Into Table In SQL |
| Video Uploader | Video From Internet Services and Social Networks Tutorials from HowTech |
| Upload Date | This Video Uploaded At 29-05-2013 22:00:42 |
| Video Discription | Follow this step by step easy tutorial to learn how to insert data into the tables in SQL Server Database via queries. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ The data inside the database is held by the tables. The data can be inserted in these tables either by the queries or even with a straightaway Graphical method. In this tutorial we will see both the methods. Step 1 -- Locating the Appropriate Database First of all, we need to locate and expand the database where that particular table is present. After that, expand the table's directory. Then we will insert the data in the Inventory table. If we move into the column section, it can be seen that there are four fields which have to be added, namely the ID, the Product Name, the Quantity and the Price. Step 2 -- Writing query for inserting record Now to insert in table, SQL query would be: Insert into Inventory (id,Product,quantity,price) values (1,'abc',12,255.32); Make sure that each value is separated by a comma. Once done, simply press F5 to execute the query. At the bottom, in the messages section, a message will appear about table rows that have been affected. Step 3 -- Another Method of Insertion We can also insert data in a table by simply giving the values straight away. For that just write the following query: Insert into Inventory values (1,'ab2',30,300.36); Make sure that the values in query in SQL inserted into table are in the same order as the order of columns in the table. Now let's execute this query and in the messages section, you can see the rows that have been affected. To insert in table, SQL queries are required to be written with much care as error can arise if we just miss to insert ellipsis even. Step 4 -- Viewing Table Data Now let's check the table to see if the data has been inserted correctly. For that let us fetch all records from the inventory table and for that, write: Select * from inventory When we execute the query, you can see all the records in the results section below, and they are exactly the same as we mentioned in the query in earlier steps. Step 5 --Alternate Method of inserting data To insert in table, SQL provides another way through which we don't have to write SQL insert into table queries. For that, just right click on the inventory table and choose the 'Edit top 200 rows' option. Step 6 -- Inserting data in Fields Over here, we can start inserting the data in the table straight away, without using the queries. All we have to do is type the records in the fields and press enter to save the changes made in each field. And that is how data is inserted in tables in SQL using insert keyword. 6WMvVwqJpN4 |
| Category | Howto & Style |
| Tags | table sql | insert table sql | insert into table in sql | query editor | sql query editor | sql base | mysql base | help sql | help mysql | sql tutorial | sql training | support sql | support mysql | sql databases | mysql databases | sql database | mysql database | about sql | about mysql | use sql | use mysql | sql backup | php sql | creating a data base | create access database | sql school | guide | education | manual | tutorial | lesson | video | instruction | tutorials | howto | how to | howtech |
