mysql表的sql语句怎么写

CREATE TABLE table_name (
    column1 datatype constraints,
    column2 datatype constraints,
    ...
);

CREATE TABLE students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    age INT
);

INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

INSERT INTO students (name, age) VALUES ('Alice', 20);

SELECT column1, column2, ... FROM table_name WHERE condition;

SELECT * FROM students WHERE age > 18;

UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;

UPDATE students SET age = 21 WHERE name = 'Alice';

DELETE FROM table_name WHERE condition;

DELETE FROM students WHERE name = 'Alice';