Single row insert
INSERT INTO users (name, email, status)
VALUES ('Rahul', 'rahul@gmail.com', 'active');
Multiple rows insert
INSERT INTO users (name, email, status)
VALUES
('Amit', 'amit@gmail.com', 'active'),
('Neha', 'neha@gmail.com', 'inactive');
Active users
SELECT * FROM users WHERE status = 'active';
Selected columns
SELECT name, email FROM users WHERE status = 'active';
Order by
SELECT * FROM users ORDER BY id DESC;
Update
UPDATE users
SET status = 'inactive' WHERE id = 5;
Multiple column update
UPDATE users
SET name = 'Rohit', email = 'rohit@gmail.com' WHERE id = 3;
Active user update
UPDATE users
SET status = 'active' WHERE email = 'amit@gmail.com';
Single row delete
DELETE FROM users WHERE id = 10;
Inactive users delete
DELETE FROM users WHERE status = 'inactive';
SAFE DELETE / UPDATE (Preview Before)
SELECT * FROM users WHERE id = 10;
DELETE FROM users WHERE id = 10;
Soft Delete (Best Practice)
डेटा delete न करके status बदलना:
UPDATE users
SET status = 'deleted' WHERE id = 7;
और fetch करते समय:
SELECT * FROM users WHERE status = 'active';
LIMIT के साथ DELETE / SELECT
DELETE FROM users ORDER BY id DESC LIMIT 1;
SELECT * FROM users LIMIT 10;
Just Basic Introduction