怎样在C#中检查mysql 的sql语句是否正确!
怎样在c#代码中,不执行语句的前提下检查mysql的sql的正确性?各位大神帮帮忙!
SQL Server的检查我已经写出来了。
bool bResult;
using (SqlConnection conn = new SqlConnection($"Data Source={ser};Initial Catalog={db};User ID={na};PWD={pw}"))
{
using (SqlCommand cmd = new SqlCommand())
{
if (conn.State != ConnectionState.Open)
conn.Open();
// cmd.ExecuteNonQuery();
try
{
cmd.Connection = conn;
cmd.CommandText = "SET PARSEONLY ON";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
bResult = true;
}
catch (Exception ex)
{
MessageBox.Show("SQL语法错误!");
bResult = false;
}
finally
{
cmd.CommandText = "SET PARSEONLY OFF";
cmd.ExecuteNonQuery();
}
}
}
return bResult;