Hope on the basis of the modification to add, thank you

CodePudding user response:

Don't know your table structure, how to do

CodePudding user response:

Rs. Fields (1), rs. Fields (2), rs. The Fields (3), rs. The Fields (4) is what ah, data types do not know, how can I help you,

CodePudding user response:

The update table name set number=number of books - 1 where ID='123456'