HOW SELECT, UPDATE, DELETE USING WHERE CLAUSE CONDITION IN DATABASE BY USING CMD
The SELECT statement is used to select data from a database.
Syntax
I)SELECT * FROM table_name;
Explanation: The table_name represents the name of the table you want to select data from.
---------------------------------------
The SQL WHERE Clause
The WHERE clause is used to filter records.
It is used to extract only those records that fulfill a specified condition.
SELECT * FROM table_name WHERE condition;
Note: The WHERE clause is not only used in SELECT statements, it is also used in UPDATE, DELETE, etc.!
---------------------------------------------------------------------------
The SQL UPDATE Statement
The UPDATE statement is used to modify the existing records in a table.
UPDATE Syntax
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
Note: Be careful when updating records in a table! Notice the WHERE clause in the UPDATE statement. The WHERE clause specifies which record(s) that should be updated. If you omit the WHERE clause, all records in the table will be updated!
----------------------------------------------------------------------------------------------------------------
The SQL DELETE Statement
The DELETE statement is used to delete existing records in a table.
DELETE Syntax
DELETE FROM table_name WHERE condition;
Note: Be careful when deleting records in a table! Notice the WHERE clause in the DELETE statement. The WHERE clause specifies which record(s) should be deleted. If you omit the WHERE clause, all records in the table will be deleted!
-------------------------------------------------------------------------------
DISCLAIMER: This video is for educational purposes only. All copyrighted materials used in this tutorial, such as images are credited to their respective owners. No infringement of copyright is intended. If any content in this video is yours and you would like it removed or credited differently, please feel free to contact me([email protected]).