.Net´´½¨MYSQL´æ´¢¹ý³ÌµÄÎÊÌâ¡£

ÏÂÃæÊǵÄÎҵĴúÂ룺
  MySqlConnection con = new MySqlConnection("Data Source=127.0.0.1;user id=root;password=11111111;initial catalog=test;");
  MySqlCommand cmd = new MySqlCommand();
  cmd.Connection = con;
  cmd.CommandType = System.Data.CommandType.Text;
  cmd.CommandText = @"CREATE PROCEDURE `PROC_Count1`(IN table_name varchar(2000), out p_Count int)
  BEGIN 
  set @p_sql= concat( 'select count(*) into ',pCount,' from (', table_name, ') ');
  PREPARE stmt_select2 from @p_sql;
  EXECUTE stmt_select2;
  DROP PREPARE stmt_select2;  
  END ;";  
  try
  {

  cmd.Connection.Open();
  int cnt = cmd.Parameters.Count;
  int ret = cmd.ExecuteNonQuery();
  }
  catch (Exception ex)
  {
  Console.WriteLine(ex.Message);
  Console.ReadLine();
  }