C# MySql 数据库连接字串符
string connStr = "" +
"Server=localhost或IP地址;port=3306;" +
"Database=你的数据库名称;" +
"User ID=root;Password=你的密码;" +
"SSLMode=none;" +
"allowPublicKeyRetrieval=true;" +
"";
using (MySqlConnection connection = new MySqlConnection(ConnStr))
{
connection.Open();
// 使用 TRUNCATE TABLE 清空表
string query = "TRUNCATE TABLE keywords";
using (MySqlCommand command = new MySqlCommand(query, connection))
{
command.ExecuteNonQuery();
MessageBox.Show("TRUNCATE OK");
}
}