Day 3 SQL Tutorial in Hindi

Опубликовано: 02 Февраль 2022
на канале: Rita Jain
154
4

What We will learn on Day 3
00:05 Brief of Day 2
10:00 To add a new column after creating table
15:00 To modify an existing column.
25:00 Retrieving Data from table based on given condition
30:00 Displaying data in ascending or descending order
Displaying records
SELECT column1, column2, ... FROM table_name;
SELECT * FROM table_name;
SELECT column1, column2, ... FROM table_name WHERE condition;
To modify an existing column.
ALTER TABLE table_name MODIFY COLUMN column_name datatype;
To add a new column after creating table:
ALTER TABLE table_name ADD column_name datatype;