notes.txt

-- SELECT * FROM users
-- SELECT name, email FROM users

-- SELECT * FROM users WHERE id = 2 OR id=3
-- SELECT * FROM users WHERE id < 3

-- SELECT COUNT(*) FROM users

-- SELECT * FROM users WHERE name LIKE 'b%'

-- SELECT * FROM users WHERE name LIKE 'Jo%e'

-- SELECT * FROM users WHERE email LIKE '%@example.com'

-- SELECT * FROM products ORDER BY price DESC;

-- SELECT * FROM products WHERE price > 30;

-- SELECT * FROM products ORDER BY price DESC LIMIT 10;

-- SELECT * FROM products WHERE category = 'Electronics' ORDER BY price DESC LIMIT 5;
-- SELECT * FROM products WHERE category LIKE 'electronics' ORDER BY price DESC LIMIT 5;


-- INSERT INTO users (name, email) VALUES ('Hasin', 'hasin@example.com')

-- INSERT INTO users (name, email) VALUES ('Rahim', 'rahim@example.com'), ('Karim', 'karim@example.com')

INSERT INTO users (name, email) VALUES ('Jashim', 'jashim@example.com')

UPDATE users SET name = 'Hasin Hayder', email = 'hasin@hasin.me' WHERE id=5 LIMIT 1

DELETE FROM users WHERE id = 7 LIMIT 1