Database ကို ဘယ်လို ဆောက်ပြီး Data တွေ ဘယ်လို သိမ်းမလဲ
Data ထုတ်ယူနည်း — SELECT, FROM, WHERE, ORDER BY, LIMIT, LIKE
Data ထည့်၊ ပြင်၊ ဖျက် — INSERT INTO, UPDATE SET, DELETE FROM
Table နှစ်ခု ချိတ်ဆက် — INNER JOIN, LEFT JOIN, RIGHT JOIN
COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING — Data ကို ခွဲခြမ်း
CREATE DATABASE, CREATE TABLE, data types (INT, VARCHAR, DATE), PRIMARY KEY, AUTO_INCREMENT
mysqli, PDO, prepared statements, fetch data, insert from PHP form
SELECT * FROM users;
SELECT name, age
FROM users
WHERE age > 18;
WHERE name = "Min"
WHERE age BETWEEN 18 AND 30
ORDER BY age DESC
LIMIT 10
INSERT INTO users
(name, age, email)
VALUES
("Min", 25, "m@m.com");
UPDATE users
SET age = 26
WHERE id = 1;
DELETE FROM users WHERE id=1;
SELECT u.name, o.total
FROM users u
INNER JOIN orders o
ON u.id = o.user_id;
SELECT COUNT(*) FROM users;
SELECT AVG(salary) FROM emp;
GROUP BY department
HAVING COUNT(*) > 5
CREATE TABLE users (
id INT AUTO_INCREMENT,
name VARCHAR(100),
PRIMARY KEY (id))
$conn = new mysqli(
"localhost","root",""
,"dbname");
$stmt = $conn->prepare(...)