c# - 检索最后插入的记录

Question

我想检索插入的数据的最后一条记录。我研究并了解到我必须使用 SELECT LAST_INSERT_ID()。我已经尝试过但不起作用。所以我在下面提供了我的代码

  //Inserting into Student Table
            string query = "INSERT INTO student(name) Values('" + txtboxname.Text + "' )";
          // query= "SELECT LAST_INSERT_ID()";
            // query += " SELECT SCOPE_IDENTITY()";
            //Inserting into course table
            string query1 = "INSERT INTO course(title) Values('" + txttitle.Text + "')";
          //  query1 = " SELECT LAST_INSERT_ID()";

            //Execute Insert Statement queries
            MySqlCommand command = new MySqlCommand(query, con);
            command.ExecuteNonQuery();
            command = new MySqlCommand(query1, con);
            command.ExecuteNonQuery();

            //Close and dispose off connections
            command.Dispose();
            con.Close();

//预览页面

        string query1 = "SELECT (name) FROM student WHERE ID = id"; 
        string query2 = "SELECT (title) FROM course WHERE ID = id";

        MySqlCommand command = new MySqlCommand(query1, con);
        lblname.Text = command.ExecuteScalar().ToString();

        command = new MySqlCommand(query2, con);
        lbltitle.Text = command.ExecuteScalar().ToString();

        con.Close();

Answer 1

如果您已将表 ID 设置为自动递增，则根据我的了解，从表中查找最大 ID，这将是您最后一次插入(如果有效)。