public string mdl_question_attempt_steps_max() { string procname = @"SELECT max(id) FROM `mdl_question_attempt_steps` WHERE 1"; DbAccessMySqlOffline db = new DbAccessMySqlOffline(); db.CreateNewSqlCommand_Text(); return(db.ExecuteData_string(procname)); }
public string mdl_logstore_standard_log_DS_Top1() { string procname = @"SELECT userid from mdl_logstore_standard_log ORDER BY mdl_logstore_standard_log.timecreated DESC LIMIT 0,1"; DbAccessMySqlOffline db = new DbAccessMySqlOffline(); db.CreateNewSqlCommand_Text(); return(db.ExecuteData_string(procname)); }
public string mdl_quiz_grades_ID_1() { string procname = @"ALTER TABLE `mdl_quiz_grades` AUTO_INCREMENT = 1"; DbAccessMySqlOffline db = new DbAccessMySqlOffline(); db.CreateNewSqlCommand_Text(); return(db.ExecuteData_string(procname)); }