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

⚡ Quick 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

On this 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.

← Previous🔎 SELECT Statements Next →✏️ UPDATE & DELETE

Code10x

INSERT Statements

INSERT ... SELECT

ON DUPLICATE KEY UPDATE