mysql数据语句怎么写

CREATE DATABASE mydatabase;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(100),
    age INT
);

ALTER TABLE users ADD COLUMN phone VARCHAR(20);

DROP TABLE users;

INSERT INTO users (name, email, age) VALUES ('John Doe', 'john@example.com', 30);

UPDATE users SET age = 31 WHERE id = 1;

DELETE FROM users WHERE id = 1;

SELECT * FROM users;

SELECT * FROM users WHERE age > 25;

SELECT * FROM users ORDER BY age DESC;

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