MYSQL在同一个表中选择

SELECT * FROM table_name;

SELECT column1, column2 FROM table_name;

SELECT * FROM table_name WHERE condition;

SELECT * FROM users WHERE age > 30;

SELECT * FROM table_name ORDER BY column ASC/DESC;

SELECT * FROM users ORDER BY age ASC;

SELECT column, COUNT(*) FROM table_name GROUP BY column;

SELECT gender, COUNT(*) FROM users GROUP BY gender;

SELECT * FROM table_name LIMIT limit OFFSET offset;

SELECT * FROM users LIMIT 10 OFFSET 10;