常用的mysql语句

CREATE DATABASE database_name;

DROP DATABASE database_name;

USE database_name;

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

DROP TABLE table_name;

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

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

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

DELETE FROM table_name WHERE condition;

SELECT column1, column2, ... FROM table_name ORDER BY column1 ASC/DESC;