INSERT Statements

Adding New Rows

💡 INSERT, EK, "NAYI, ENTRY" ADD, karna, hai, EK, filing, cabinet, mein — TUM, SPECIFY, karte, HO, KAUN, se, columns, mein, KYA, VALUES, jaani, HAIN.

INSERT INTO table (columns) VALUES (values), EK, SINGLE, row, ADD, karta hai. MULTIPLE, rows, EK, HI, statement, mein, ADD, ki, ja, sakti, HAIN, comma-separated, VALUE, sets, se — YE, MULTIPLE, separate, INSERT, statements, se, FASTER, hai.

AUTO_INCREMENT, columns, (jaise, id) ke, liye, VALUE, PROVIDE, karne, ki, ZAROORAT, nahi, — MySQL, automatically, NEXT, value, ASSIGN, kar, deta hai.

-- Single row:
INSERT INTO users (name, email) VALUES ('Aarav', 'aarav@example.com');

-- Multiple rows, ek, hi, statement, mein (FASTER):
INSERT INTO users (name, email) VALUES
  ('Priya', 'priya@example.com'),
  ('Rohan', 'rohan@example.com');

➕

INSERT, EK, "NAYI, ENTRY" ADD, karna, hai, EK, filing, cabinet, mein — TUM, SPECIFY, karte, HO, KAUN, se, columns, mein, KYA, VALUES, jaani, HAIN.

1 / 2

⚡ झट से Recap

INSERT INTO table (cols) VALUES (vals) = naya, row, add, karta, hai
Multiple rows, ek, hi, statement, mein, add, ki, ja, sakti, hain (faster)
AUTO_INCREMENT columns, ke, liye, value, provide, karne, ki, ZAROORAT, nahi

इस page में (2 subtopics)

INSERT INTO table SELECT ..., ek, TABLE, se, data, PICK, karke, DUSRI, table, mein, INSERT, karta hai — ek, backup, table, banaне, ya, data, migration, ke, liye, USEFUL, hai.

INSERT INTO archived_orders
SELECT * FROM orders WHERE created_at < '2023-01-01';

INSERT ... ON DUPLICATE KEY UPDATE, MySQL-specific, syntax, hai — agar, INSERT, EK, EXISTING, unique, key, se, CONFLICT, karta, hai, INSTEAD, of, error, throw, karne, ke, EK, UPDATE, ki, tarah, BEHAVE, karta hai.

💡Tip: Ye, "upsert" pattern, ka, MySQL, way, hai — MongoDB, ke, upsert: true, option, ke, similar, concept.

← पिछला🔎 SELECT Statements अगला →✏️ UPDATE & DELETE

Code10x

INSERT Statements

INSERT ... SELECT

ON DUPLICATE KEY UPDATE