如何在Slick中从最后一条SQL语句中获取结果

import slick.jdbc.MySQLProfile.api._

// 1. 创建Slick会话对象
val db = Database.forConfig("your-database-config")

// 2. 定义一个表对象，对应数据库中的表
class MyTable(tag: Tag) extends Table[(Int, String)](tag, "my_table") {
  def id = column[Int]("id", O.PrimaryKey)
  def name = column[String]("name")
  def * = (id, name)
}

val myTable = TableQuery[MyTable]

// 3. 构建SQL查询语句
val query = myTable.sortBy(_.id.desc).take(1)

// 4. 执行查询并获取结果
val result = db.run(query.result)

// 处理结果
result.onComplete {
  case Success(records) => 
    val lastRecord = records.headOption
    lastRecord.foreach { record =>
      val id = record._1
      val name = record._2
      println(s"Last record: ID=$id, Name=$name")
    }
  case Failure(ex) => 
    println(s"Failed to retrieve last record: ${ex.getMessage}")
}