Create array on c# to create many table on mysql

MySqlConnection conDatabase = new MySqlConnection("Data Source=localhost;" +
                                   "Persist Security Info=yes;" +
                                   "UserId=tee; PWD=t439; database=p3;");
        MySqlCommand cmdDatabase = new MySqlCommand("DROP TABLE IF EXISTS `q_mem_sur`; create table q_mem_sur as SELECT Count(*) As rowa,  member.Ssurname,  Sum(Case When ((member.status = '1')) Then 1 Else 0 End) As Status11 From member Group By member.Ssurname Order By rowa Desc;", conDatabase);

        conDatabase.Open();

        cmdDatabase.CommandTimeout = 500;
        cmdDatabase.ExecuteNonQuery();
        conDatabase.Close();

I try to create many table so i think i should use array and loop it please give me some example thank you