Basic Queries

Basic MySQL Queries

INSERT INTO users (username, email, password)
VALUES ('alice', 'alice@example.com', 'hashed_pw');

SELECT * FROM users;
SELECT id, username, email FROM users;
SELECT username FROM users WHERE id = 1;

UPDATE users
SET email = 'new@example.com'
WHERE id = 1;

DELETE FROM users WHERE id = 5;

TRUNCATE TABLE users;  -- removes all rows, keeps structure
DROP TABLE users;       -- removes table entirely

Pro Tip

Always use a WHERE clause with UPDATE and DELETE to avoid modifying all rows.