how to update

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rak53820
    New Member
    • Jul 2007
    • 4

    how to update

    how to automatically update only last row in the table?

    eg: i have like this

    id name date

    21 aaa 17/02/07
    08 pppp 01/04/07
    15 kkk 07/07/07
    29 llllll 30/06/07
    29 llllll 30/06/07
    . . .
    . . .
    . . . so on....


    i want automatically update last row in the table ?
  • JosAH
    Recognized Expert MVP
    • Mar 2007
    • 11453

    #2
    Originally posted by rak53820
    how to automatically update only last row in the table?

    eg: i have like this

    id name date

    21 aaa 17/02/07
    08 pppp 01/04/07
    15 kkk 07/07/07
    29 llllll 30/06/07
    29 llllll 30/06/07
    . . .
    . . .
    . . . so on....


    i want automatically update last row in the table ?
    You have to decide *what* you consider the 'last row in the table'. If you have
    done that you have to find the primary key value for that row. Once you have
    that you can update that row using a SQL update statement and JDBC of course.

    kind regards,

    Jos

    Comment

    Working...