INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4

Rishabh Mishra
Rishabh Mishra
226 هزار بار بازدید - 2 سال پیش - SQL Full Course Playlist 👇
SQL Full Course Playlist 👇
SQL Tutorial In Hindi

Timestamps:
00:00 Topics
00:04 Insert Into Concept
00:28 Insert Into Example
01:38 Update Table Concept
02:12 Update Table Example
02:55 Delete Values Concept
03:11 Delete Values Example
03:41 Alter Table Concept
04:37 Drop & Truncate Table Concept
05:01 Drop & Truncate Table Example

Like, Share, Subscribe :)

➖➖➖➖➖➖➖➖➖➖➖➖➖
Queries used:

👉 Customer Table
🔖 Create table

CREATE TABLE customer
(
CustID int PRIMARY KEY,
CustName varchar(50) NOT NULL,
Age int NOT NULL,
City char(50),
Salary numeric );

🔖 Insert values in table

INSERT INTO customer (CustID, CustName, Age, City, Salary)
VALUES
(1, 'sam', 26, 'Delhi', 9008),
(2, 'Ram', 19, 'Bangalore', 11000),
(3, 'Pam', 31, 'Mumbai', 6060),
(4, 'Sam', 42, 'Pune', 10000);

🔖 Update values in table

UPDATE customer
SET CustName = 'Xam' , Age = 32
WHERE CustID = 4


👉 Classroom Table

CREATE TABLE classroom (
rollno int8 PRIMARY KEY,
name varchar(50) NOT NULL,
house char(12) NOT NULL,
grade char(1) );

INSERT INTO classroom (rollno, name, house, grade)
VALUES
(1, 'Sam', 'Akash', 'B'),
(2, 'Ram', 'Agni', 'A'),
(3, 'Shyam', 'Jal', 'B'),
(4, 'Sundar', 'Agni', 'A'),
(5, 'Ram', 'Yayu', 'B');
➖➖➖➖➖➖➖➖➖➖➖➖➖

Related Videos
Introduction to SQL - What Is SQL + Database | SQL Tutorial In Hindi - 1
What Is SQL ? | Database in SQL | SQL...

Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi - 2
Data Types, Primary-Foreign Keys & Co...

Create Table In SQL & Create Database | SQL Tutorial In Hindi - 3
Create Table In SQL & Create Database...

➖➖➖➖➖➖➖➖➖➖➖➖➖
Connect on other Social Media handles:

Instagram: Instagram: rishabhnmishra
LinkedIn: LinkedIn: rishabhnmishra
Twitter: Twitter: rishabhnmishra  

➖➖➖➖➖➖➖➖➖➖➖➖➖

If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh Mishra and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students.
Have a great day buddy!
2 سال پیش در تاریخ 1401/07/07 منتشر شده است.
226,083 بـار بازدید شده
... بیشتر