Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How to Update Query 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. [t5nTBMSca3s]
| Name | How to Update Query 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 use Update query in SQL together with where clause. 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+ An Update query in SQL is used to modify the present records in the existing table. A "Where" clause has to be used with the Update query to specify the row which has to be modified, otherwise all the rows in the table will get effected. Step 1- Displaying Employee Table First of all, let us fetch all records from the table and after that we will update the table by Update query of SQL. For that simply write: Select * from EMP Step 2-Update Query Now , if we want to update the salary for Jones, first we will use Update keyword along with the particular table name which is EMP in our case, then we have to specify its employee Number in the where clause. Together the query in SQL would be something like this: Update EMP Set Sal=3500 Where EMPNO=7566 Execute it by pressing F5. Step 3-Done with Update Now fetch the data from employee table again and see that that salary of Employee No. 7566 has been updated to the amount specified earlier in Update query of SQL And this is how we can use Update query in SQL. t5nTBMSca3s |
| Category | Howto & Style |
| Tags | basic sql queries | sql query examples | sql queries | update query sql | update query | query sql | 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 |
