Home

1. What are differences between the DELETE and TRUNCATE statement? Answer Delete only deletes a row and is slower than truncate. Truncate deletes all the rows and cannot be rolled back. 2. What are the different subsets of SQL? Answer Data Definition Language (Allows you to create and delete objects), Data Manipulation Language (Allows manipulation… Read more

In this tutorial we will be using MYSQL Workbench. I will assume you already have MYSQL Workbench set up and are connected to it. The update command is used to modify existing records in a table. You can update two different ways. Either using a WHERE clause or without WHERE clause. Using the WHERE clause… Read more