MySQL是一種廣泛使用的關系型數據庫管理系統。在使用MySQL時，有很多方法可以用來實現不同的操作。以下是一些方法的匯總：

1. 創建數據庫
CREATE DATABASE dbname;
2. 刪除數據庫
DROP DATABASE dbname;
3. 使用數據庫
USE dbname;
4. 創建表格
CREATE TABLE tablename (
column1 datatype,
column2 datatype,
column3 datatype,
.....
);
5. 查看表格結構
DESCRIBE tablename;
6. 刪除表格
DROP TABLE tablename;
7. 插入數據
INSERT INTO tablename (column1, column2, column3, .....)
VALUES (value1, value2, value3, .....)
8. 更新數據
UPDATE tablename SET column1=new_value1, column2=new_value2, .... WHERE condition;
9. 刪除數據
DELETE FROM tablename WHERE condition;
10. 查詢數據
SELECT column1, column2, .... FROM tablename WHERE condition;
11. 連接表格
SELECT column1, column2, .... FROM tablename1 JOIN tablename2 ON tablename1.column1 = tablename2.column2;
12. 排序數據
SELECT column1, column2, .... FROM tablename ORDER BY column1 ASC/DESC;
13. 分組數據
SELECT column1, COUNT(*) FROM tablename GROUP BY column1;
14. 聚合函數
SELECT MAX(column1), MIN(column2), AVG(column3), SUM(column4) FROM tablename;
15. 定義視圖
CREATE VIEW viewname AS SELECT column1, column2, .... FROM tablename WHERE condition;
16. 刪除視圖
DROP VIEW viewname;
17. 創建索引
CREATE INDEX indexname ON tablename(column1, column2, ....);
18. 刪除索引
DROP INDEX indexname ON tablename;