← 返回教程列表
🐬 MySQL 教程
查询进阶
SELECT * FROM users WHERE age > 18;
SELECT * FROM users ORDER BY age DESC;
SELECT * FROM users LIMIT 10 OFFSET 0;
SELECT u.name, o.amount FROM users u JOIN orders o ON u.id = o.user_id;SELECT * FROM users WHERE age > 18;
SELECT * FROM users ORDER BY age DESC;
SELECT * FROM users LIMIT 10 OFFSET 0;
SELECT u.name, o.amount FROM users u JOIN orders o ON u.id = o.user_id;