Data insertion method and device and data query method and device

The invention discloses a data insertion method and device and a data query method and device, and relates to the technical field of database operation. A specific embodiment of the method comprises the steps of receiving an insertion request for a database, and obtaining a to-be-inserted record corresponding to the insertion request; determining whether the record to be inserted contains sensitive information; in response to sensitive information contained in the to-be-inserted record, obtaining at least one piece of sensitive information contained in the to-be-inserted record, and generating a splicing field corresponding to the at least one piece of sensitive information; encrypting the spliced field by using a first cryptographic algorithm to generate a data ciphertext, and generating summary information corresponding to the spliced field by using a second cryptographic algorithm; and storing the data ciphertext and the summary information in a data table corresponding to the to-be-inserted ...