编写MySQL语句需要了解MySQL的语法和常用操作，以下是一些常用的MySQL语句编写方法：

1. 创建数据库：

CREATE DATABASE database_name;

2. 切换数据库：

USE database_name;

3. 删除数据库：

DROP DATABASE database_name;

4. 创建表：

CREATE TABLE table_name (

column1 datatype constraints,

column2 datatype constraints,

...

);

5. 删除表：

DROP TABLE table_name;

6. 修改表结构：

ALTER TABLE table_name

ADD column_name datatype constraints,

DROP column_name,

ALTER column_name datatype,

...

;

7. 插入记录：

INSERT INTO table_name (column1, column2, ...)

VALUES (value1, value2, ...);

8. 更新记录：

UPDATE table_name

SET column1 = value1, column2 = value2, ...

WHERE condition;

9. 删除记录：

DELETE FROM table_name

WHERE condition;

10. 查询记录：

SELECT column1, column2, ...

FROM table_name

WHERE condition

ORDER BY column_name ASC/DESC

LIMIT n;

11. 连接表查询：

SELECT column1, column2, ...

FROM table_name1

JOIN table_name2 ON table_name1.column_name = table_name2.column_name

WHERE condition;

12. 聚合函数查询：

SELECT COUNT(column_name) AS count FROM table_name;

SELECT AVG(column_name) AS average FROM table_name;

SELECT MAX(column_name) AS maximum FROM table_name;

SELECT MIN(column_name) AS minimum FROM table_name;

SELECT SUM(column_name) AS total FROM table_name;

...

13. 分组查询：

SELECT column1, column2, ...

FROM table_name

GROUP BY column_name

HAVING condition;

14. 子查询：

SELECT column1, column2, ...

FROM table_name1

WHERE column_name IN (SELECT column_name FROM table_name2 WHERE condition);

15. 创建索引：

CREATE INDEX index_name

ON table_name (column_name);

以上是一些常用的MySQL语句编写方法，你可以根据具体的需求进行调整和组合使用。同时，需要注意MySQL的语法规范和具体的约束条件，以确保语句的正确性和有效性。