C# (CSharp) http请求服务.dal MysqlHelper.ExecuteScalar Examples

Example #1

        public static string CreatlogTable_供应商()
        {
            string sdt       = DateTime.Now.ToString("yyyy");
            string tablename = "log_" + sdt;

            string s_sql = "SELECT table_name FROM information_schema.TABLES WHERE table_name ='" + tablename + "' and `table_schema`='supplier' ";
            object ob    = MysqlHelper.ExecuteScalar(s_sql, ref Program.myPool_supplier);

            if (ob == null)
            {
                string sql = "CREATE TABLE  IF NOT EXISTS `" + tablename + "`  LIKE  `log_mb`";
                MysqlHelper.ExecuteNonQuery(sql, ref Program.myPool_supplier);
            }

            return(tablename);
        }