MySQL Tutorial Part - 3 | Data Manipulation Language (DML) | How to Insert, update and Delete value

DML - DATA MANIPULATION LANGUAGE

INSERT - INSERT INTO 'table_name' (column1 , column2 , column n )
values ( value1 , value 2 ,value n) ;
INSERT INTO 'table_name' values
(value1 , value2 , value n);


SELECT - SELECT * from 'table_name' ; # * - ALL ( (All information from the table)
SELECT column1 , column2 , column n FROM 'table_name';
SELECT * (or) column1 , column2 FROM 'table_name' WHERE [CONDITION] ;


UPDATE - UPDATE 'table_name' SET 'column_name' = 'required_value' ;
UPDATE 'table_name' SET 'column_name' = 'req_value' WHERE [CONDITION] ; # updates specific record .


DELETE - DELETE FROM 'table_name' ; # deletes entire information from the table.
DELETE FROM 'table_name' WHERE [condition] ; # deletes specific record based on the condition .


MySQL Tutorial in Tamil (1) - Types of Data - Part 1

https://youtu.be/4UvwdrZQwUQ

MySQL Tutorial - PART 2 - Data Definition Language (DDL) - Types of SQL Statements - MySQL

https://youtu.be/zifN7cI2yGY

MySQL Tutorial - Part - 4 | Transaction control language (TCL) | Savepoint, Rollback and Commit

https://youtu.be/84LWyt9piBo

MySQL Tutorial Part - 5 | Data Control Language (DCL) | Grant, Revoke and Create User |

https://youtu.be/HXVEiFpYL2Q

MySQL Tutorial - Part-6 | Not null, Unique, Primary key, Check, Default & Auto_increment

https://youtu.be/kSYPo-3Ccrw