โNext slideโPrevious slideSpacePlay / PauseMNarration on/offFFullscreen?Show/hide this
Press any key to close
Skill Topic ยท Cinematic
๐ Topic 03: INSERT Data โ Data Bharo Table Me!
"An empty table is like an empty stomach โ useless!" โ Unknown "Table bana liya? Ab usse data seโฆ
Overview
๐ Topic 03: INSERT Data โ Data Bharo Table Me! โ Quick Facts
๐
id: name
๐ฏ
1: Rahul Sharma
โก
2: Priya Singh
๐
3: Amit Kumar
Topic 1
Setup: Pehle Tables Banao
๐`sql -- โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ -- Practice ke liye database + tablesโฆ
Topic 2
1. INSERT INTO โ Basic Syntax
๐พ`sql -- Syntax 1: Sab columns specify karo INSERT INTO table_name (column1, column2,โฆ
Topic 3
2. Single Row Insert
๐๏ธBasic Insert: `sql -- โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ -- Ek student add karoโฆ
Topic 4
3. Multiple Rows Insert
๐Ek hi query me bahut saare rows add karo โ faster + cleaner! `sql --โฆ
Topic 5
4. Partial Insert โ Kuch Columns Me
๐Sab columns me data dena zaroori nahi โ sirf required ones me do: `sql -- Sirf naam aurโฆ
Topic 6
5. DEFAULT Values
๐DEFAULT Keyword Use Karna: `sql -- Explicitly DEFAULT likho INSERT INTO students (name,โฆ
Topic 7
6. INSERT with SELECT
๐งฎEk table se data nikaal ke dusri table me daalo: `sql --โฆ
Topic 8
7. INSERT IGNORE โ Errors Ignore Karo
๐Agar UNIQUE ya PRIMARY KEY violation ho to error ke bajaye skip kar do: `sql --โฆ
Topic 9
8. ON DUPLICATE KEY UPDATE
๐Agar duplicate ho, to INSERT ke bajaye UPDATE kar do โ UPSERT technique: `sql --โฆ