package main\n\nimport \"fmt\"\n\nfunc main() {\n fmt.Println(\"Hello, MySQL!\") \/\/ \u8f93\u51fa\u95ee\u5019\u8bed\uff0c\u9a8c\u8bc1\u73af\u5883\u662f\u5426\u6b63\u5e38\n}\n<\/code><\/pre>\n\n\n\n\u8fd0\u884c\u547d\u4ee4\uff1a<\/p>\n\n\n\n
go run hello.go<\/code><\/pre>\n\n\n\n\u82e5\u63a7\u5236\u53f0\u8f93\u51faHello, MySQL!<\/code>\uff0c\u8bf4\u660e\u73af\u5883\u642d\u5efa\u5b8c\u6210\uff5e<\/p>\n\n\n\n\u4e8c\u3001Go \u57fa\u7840\u8bed\u6cd5\u901f\u901a\uff08\u4e3a\u64cd\u4f5c MySQL \u94fa\u57ab\uff09<\/h2>\n\n\n\n1. \u53d8\u91cf\u8d4b\u503c\u4e0e\u8f93\u51fa<\/h3>\n\n\n\n Go \u7684\u53d8\u91cf\u58f0\u660e\u652f\u6301\u591a\u79cd\u65b9\u5f0f\uff0c\u7075\u6d3b\u5ea6\u5f88\u9ad8\uff1a<\/p>\n\n\n\n
package main\n\nimport \"fmt\"\n\nfunc main() {\n var intA = 10 \/\/ \u81ea\u52a8\u63a8\u5bfc\u7c7b\u578b\n var charA = \"a\" \/\/ \u5b57\u7b26\u4e32\u7c7b\u578b\n var charB string = \"b\" \/\/ \u663e\u5f0f\u58f0\u660e\u7c7b\u578b\n intB := 20 \/\/ \u77ed\u53d8\u91cf\u58f0\u660e\uff08\u4ec5\u652f\u6301\u51fd\u6570\u5185\uff09\n var intC, intD = 30, 40 \/\/ \u591a\u53d8\u91cf\u540c\u65f6\u58f0\u660e\n \n \/\/ \u4e09\u79cd\u8f93\u51fa\u65b9\u5f0f\u5bf9\u6bd4\n fmt.Print(\"\u4e0d\u6362\u884c\u8f93\u51fa\uff1a\") \/\/ \u4e0d\u81ea\u52a8\u6362\u884c\n fmt.Printf(\"intA=%v, intB=%v\\n\", intA, intB) \/\/ \u683c\u5f0f\u5316\u8f93\u51fa\uff08\u63a8\u8350\uff09\n fmt.Println(\"\u6362\u884c\u8f93\u51fa\uff1a\", charA, charB, intC, intD) \/\/ \u81ea\u52a8\u6362\u884c\n}\n<\/code><\/pre>\n\n\n\n\u8fd0\u884c\u7ed3\u679c\uff1a<\/p>\n\n\n\n2. \u6570\u7ec4\u4e0e\u5207\u7247\uff08\u5b58\u50a8\u67e5\u8be2\u7ed3\u679c\u5e38\u7528\uff09<\/h3>\n\n\n\n \u5207\u7247\u662f Go \u4e2d\u6700\u5e38\u7528\u7684\u6570\u636e\u7ed3\u6784\uff0c\u6bd4\u6570\u7ec4\u66f4\u7075\u6d3b\uff1a<\/p>\n\n\n\n
package main\n\nimport \"fmt\"\n\nfunc main() {\n\t\/\/ \u6570\u7ec4\uff08\u56fa\u5b9a\u957f\u5ea6\uff09\n\tlevel := [3]string{\"\u521d\u7ea7\", \"\u4e2d\u7ea7\", \"\u9ad8\u7ea7\"}\n\tfmt.Println(\"\u6570\u7ec4\uff1a\", level[0]) \/\/ \u8bbf\u95ee\u6570\u7ec4\u5143\u7d20\n\n\t\/\/ \u5207\u7247\uff08\u52a8\u6001\u957f\u5ea6\uff09\n\tvar names []string \/\/ \u58f0\u660e\u7a7a\u5207\u7247\n\tnum := []int{1, 2, 3, 4, 5} \/\/ \u521d\u59cb\u5316\u5e26\u5143\u7d20\u7684\u5207\u7247\n\n\t\/\/ \u5207\u7247\u622a\u53d6\uff08\u5de6\u95ed\u53f3\u5f00\uff09\n\tslice := num[1:3] \/\/ \u622a\u53d6\u7d22\u5f151-2\u7684\u5143\u7d20\uff0c\u7ed3\u679c\uff1a[2,3]\n\tfmt.Println(\"\u5207\u7247\u622a\u53d6\uff1a\", slice)\n\n\t\/\/ \u5207\u7247\u6dfb\u52a0\u5143\u7d20\uff08\u8fd4\u56de\u65b0\u5207\u7247\uff09\n\tnames = append(names, \"zhangsan\")\n\tfmt.Println(\"\u6dfb\u52a0\u5143\u7d20\u540e\uff1a\", names) \/\/ \u7ed3\u679c\uff1a[zhangsan]\n}<\/code><\/pre>\n\n\n\n3. \u7ed3\u6784\u4f53\uff08\u6620\u5c04 MySQL \u8868\u6570\u636e\uff09<\/h3>\n\n\n\n \u64cd\u4f5c\u6570\u636e\u5e93\u65f6\uff0c\u5e38\u7528\u7ed3\u6784\u4f53\u5b58\u50a8\u4e00\u884c\u6570\u636e\uff1a<\/p>\n\n\n\n
package main\n\nimport \"fmt\"\n\ntype Person struct {\n\tname string\n\tage int\n\tcity string\n}\n\nfunc main() {\n\tp1 := Person{\n\t\tname: \"\u5f20\u4e09\",\n\t\tage: 20,\n\t\tcity: \"\u829c\u6e56\",\n\t}\n\n\tp2 := Person{\"\u674e\u56db\", 21, \"\u5408\u80a5\"}\n\n\tfmt.Println(p1)\n\tfmt.Println(p2)\n\n\tfmt.Println(p1.name)\n\tp1.age = 22\n\tfmt.Println(p1.age)\n\n\tfmt.Printf(\"p1\u7684\u59d3\u540d\u662f\uff1a%s\uff0c\u5e74\u9f84\u662f\uff1a%d\uff0c\u57ce\u5e02\u662f\uff1a%s\\n\", p1.name, p1.age, p1.city)\n\tfmt.Printf(\"p2:%v\\n\", p2)\n}<\/code><\/pre>\n\n\n\n4. \u5faa\u73af\u4e0e\u6761\u4ef6\u5224\u65ad\uff08\u6570\u636e\u5904\u7406\u5e38\u7528\uff09<\/h3>\n\n\n\npackage main\n\nimport \"fmt\"\n\nfunc main() {\n \/\/ \u6761\u4ef6\u5224\u65ad\uff08\u6210\u7ee9\u8bc4\u7ea7\uff09\n score := 85\n var grade string\n if score >= 90 {\n grade = \"A\"\n } else if score >= 80 {\n grade = \"B\"\n } else if score >= 60 {\n grade = \"C\"\n } else {\n grade = \"F\"\n }\n fmt.Printf(\"\u6210\u7ee9\uff1a%d\uff0c\u8bc4\u7ea7\uff1a%s\\n\", score, grade)\n \n \/\/ \u5faa\u73af\uff08\u904d\u5386\u5207\u7247\uff09\n fruits := []string{\"\u82f9\u679c\", \"\u9999\u8549\", \"\u6a59\u5b50\"}\n for index, fruit := range fruits {\n fmt.Printf(\"\u7d22\u5f15\uff1a%d\uff0c\u6c34\u679c\uff1a%s\\n\", index, fruit)\n }\n}<\/code><\/pre>\n\n\n\n\u4e09\u3001Go \u64cd\u4f5c MySQL \u5b9e\u6218\uff08\u6838\u5fc3\u90e8\u5206\uff09<\/h2>\n\n\n\n1. \u524d\u7f6e\u51c6\u5907\uff1a\u521b\u5efa MySQL \u7528\u6237\u548c\u8868<\/h3>\n\n\n\n \u9996\u5148\u5728 MySQL \u4e2d\u6267\u884c\u4ee5\u4e0b SQL\uff0c\u521b\u5efa\u6d4b\u8bd5\u7528\u6237\u548c\u8868\uff1a<\/p>\n\n\n\n
-- \u521b\u5efaGo\u4e13\u7528\u64cd\u4f5c\u7528\u6237\nCREATE USER 'go_rw'@'%' IDENTIFIED BY 'Ud7q_dac8';\n-- \u6388\u6743\u589e\u5220\u6539\u67e5\u6743\u9650\nGRANT insert,delete,select,update ON maria.* TO 'go_rw'@'%';\n-- \u5207\u6362\u6570\u636e\u5e93\nUSE maria;\n-- \u521b\u5efa\u7528\u6237\u8868\nCREATE TABLE user_info (\n id INT AUTO_INCREMENT PRIMARY KEY, -- \u81ea\u589e\u4e3b\u952e\n name VARCHAR(255) NOT NULL, -- \u59d3\u540d\n age INT NOT NULL -- \u5e74\u9f84\n);\n<\/code><\/pre>\n\n\n\n2. Go \u64cd\u4f5c MySQL \u6838\u5fc3\u4ee3\u7801<\/h3>\n\n\n\n\u6b65\u9aa4 1\uff1a\u5b89\u88c5 MySQL \u9a71\u52a8\u4f9d\u8d56<\/h4>\n\n\n\n \u6253\u5f00\u7ec8\u7aef\uff0c\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u5b89\u88c5 Go \u7684 MySQL \u9a71\u52a8\uff1a<\/p>\n\n\n\n
go get github.com\/go-sql-driver\/mysql<\/code><\/pre>\n\n\n\n\u6b65\u9aa4 2\uff1a\u5b8c\u6574 CRUD \u4ee3\u7801\u5b9e\u73b0<\/h4>\n\n\n\npackage main\n\nimport (\n \"database\/sql\"\n \"fmt\"\n \/\/ MySQL\u9a71\u52a8\uff08\u4e0b\u5212\u7ebf\u8868\u793a\u53ea\u5bfc\u5165\u4e0d\u4f7f\u7528\uff0c\u5e95\u5c42\u4f1a\u81ea\u52a8\u6ce8\u518c\uff09\n _ \"github.com\/go-sql-driver\/mysql\"\n)\n\n\/\/ UserInfo \u7ed3\u6784\u4f53\u6620\u5c04user_info\u8868\ntype UserInfo struct {\n ID int `db:\"id\"`\n Name string `db:\"name\"`\n Age int `db:\"age\"`\n}\n\nfunc main() {\n \/\/ 1. \u8fde\u63a5MySQL\u6570\u636e\u5e93\n \/\/ \u8fde\u63a5\u683c\u5f0f\uff1a\u7528\u6237\u540d:\u5bc6\u7801@tcp(IP:\u7aef\u53e3)\/\u6570\u636e\u5e93\u540d?charset=utf8mb4\n db, err := sql.Open(\"mysql\", \"go_rw:Ud7q_dac8@tcp(192.168.184.151:3306)\/maria?charset=utf8mb4\")\n if err != nil {\n panic(\"\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25\uff1a\" + err.Error())\n }\n defer db.Close() \/\/ \u5ef6\u8fdf\u5173\u95ed\u8fde\u63a5\uff08\u7a0b\u5e8f\u7ed3\u675f\u524d\u6267\u884c\uff09\n \n \/\/ \u9a8c\u8bc1\u8fde\u63a5\u662f\u5426\u6709\u6548\n err = db.Ping()\n if err != nil {\n panic(\"\u8fde\u63a5\u9a8c\u8bc1\u5931\u8d25\uff1a\" + err.Error())\n }\n fmt.Println(\"\u6570\u636e\u5e93\u8fde\u63a5\u6210\u529f\uff01\")\n \n \/\/ 2. \u63d2\u5165\u6570\u636e\uff08\u4f7f\u7528\u9884\u7f16\u8bd1\u9632\u6b62SQL\u6ce8\u5165\uff09\n insertSQL := \"INSERT INTO user_info(name, age) VALUES(?, ?)\"\n stmt, err := db.Prepare(insertSQL)\n if err != nil {\n panic(\"\u9884\u7f16\u8bd1\u63d2\u5165SQL\u5931\u8d25\uff1a\" + err.Error())\n }\n defer stmt.Close()\n \n \/\/ \u6267\u884c\u63d2\u5165\uff08\u53c2\u6570\u5bf9\u5e94SQL\u4e2d\u7684?\uff09\n result, err := stmt.Exec(\"John Doe\", 25)\n if err != nil {\n panic(\"\u63d2\u5165\u6570\u636e\u5931\u8d25\uff1a\" + err.Error())\n }\n insertID, _ := result.LastInsertId()\n fmt.Printf(\"\u63d2\u5165\u6210\u529f\uff0c\u65b0\u8bb0\u5f55ID\uff1a%d\\n\", insertID)\n \n \/\/ 3. \u67e5\u8be2\u6570\u636e\n querySQL := \"SELECT id, name, age FROM user_info\"\n rows, err := db.Query(querySQL)\n if err != nil {\n panic(\"\u67e5\u8be2\u6570\u636e\u5931\u8d25\uff1a\" + err.Error())\n }\n defer rows.Close()\n \n var users []UserInfo \/\/ \u5b58\u50a8\u67e5\u8be2\u7ed3\u679c\n for rows.Next() {\n var user UserInfo\n \/\/ \u626b\u63cf\u884c\u6570\u636e\u5230\u7ed3\u6784\u4f53\uff08\u5b57\u6bb5\u987a\u5e8f\u9700\u4e0e\u67e5\u8be2\u8bed\u53e5\u4e00\u81f4\uff09\n err := rows.Scan(&user.ID, &user.Name, &user.Age)\n if err != nil {\n panic(\"\u6570\u636e\u626b\u63cf\u5931\u8d25\uff1a\" + err.Error())\n }\n users = append(users, user)\n }\n \n \/\/ \u6253\u5370\u67e5\u8be2\u7ed3\u679c\n fmt.Println(\"\\n\u67e5\u8be2\u7ed3\u679c\uff1a\")\n for _, u := range users {\n fmt.Printf(\"ID\uff1a%d\uff0c\u59d3\u540d\uff1a%s\uff0c\u5e74\u9f84\uff1a%d\\n\", u.ID, u.Name, u.Age)\n }\n \n \/\/ 4. \u66f4\u65b0\u6570\u636e\n updateSQL := \"UPDATE user_info SET name=?, age=? WHERE id=?\"\n stmtUpdate, err := db.Prepare(updateSQL)\n if err != nil {\n panic(\"\u9884\u7f16\u8bd1\u66f4\u65b0SQL\u5931\u8d25\uff1a\" + err.Error())\n }\n defer stmtUpdate.Close()\n \n resultUpdate, err := stmtUpdate.Exec(\"Jane Smith\", 30, insertID)\n if err != nil {\n panic(\"\u66f4\u65b0\u6570\u636e\u5931\u8d25\uff1a\" + err.Error())\n }\n affectedRows, _ := resultUpdate.RowsAffected()\n fmt.Printf(\"\\n\u66f4\u65b0\u6210\u529f\uff0c\u5f71\u54cd\u884c\u6570\uff1a%d\\n\", affectedRows)\n \n \/\/ 5. \u5220\u9664\u6570\u636e\n deleteSQL := \"DELETE FROM user_info WHERE id=?\"\n stmtDelete, err := db.Prepare(deleteSQL)\n if err != nil {\n panic(\"\u9884\u7f16\u8bd1\u5220\u9664SQL\u5931\u8d25\uff1a\" + err.Error())\n }\n defer stmtDelete.Close()\n \n resultDelete, err := stmtDelete.Exec(insertID)\n if err != nil {\n panic(\"\u5220\u9664\u6570\u636e\u5931\u8d25\uff1a\" + err.Error())\n }\n deleteRows, _ := resultDelete.RowsAffected()\n fmt.Printf(\"\u5220\u9664\u6210\u529f\uff0c\u5f71\u54cd\u884c\u6570\uff1a%d\\n\", deleteRows)\n}\n<\/code><\/pre>\n\n\n\n\u6b65\u9aa4 3\uff1a\u8fd0\u884c\u4ee3\u7801<\/h4>\n\n\n\n \u5c06\u4e0a\u8ff0\u4ee3\u7801\u4fdd\u5b58\u4e3amysql_demo.go<\/code>\uff0c\u5728\u7ec8\u7aef\u6267\u884c\uff1a<\/p>\n\n\n\ngo run mysql_demo.go\n<\/code><\/pre>\n\n\n\n\u6210\u529f\u8fd0\u884c\u540e\uff0c\u63a7\u5236\u53f0\u8f93\u51fa\u5982\u4e0b\uff1a<\/p>\n\n\n\n
![\"\"](\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/03\/image-29-1024x118.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/03\/image-32-1024x164.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/03\/image-33-1024x125.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/03\/image-34-1024x137.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/03\/image-35-1024x208.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/03\/image-36-1024x171.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/03\/image-38-1024x228.png\")
<\/figure>\n\n\n\n