mysql設定編碼的命令是什麼

mysql設定編碼的命令是：【SET character_set_database = utf8;】。我們可以通過執行【SHOW VARIABLES LIKE '%set%';】命令來檢視資料庫編碼。

一、檢視編碼

（推薦教學：）

SHOW VARIABLES LIKE '%set%';

二、將編碼設定為UTF-8

SET character_set_client = utf8;
SET character_set_connection = utf8;
SET character_set_database = utf8;
SET character_set_database = utf8;
SET character_set_results = utf8;
SET character_set_server = utf8;
SET character_set_system = utf8;