Encrypt querys mysql

[weslleysolo]

Hello, I have a Delphi application and want to know how to encrypt my querys. The application runs on a local server.

Ex:

Code: Select all

SELECT administracaoxitemxprescricao.CD_USUARIO, administracaoxitemxprescricao.DS_DIA, administracaoxitemxprescricao.DS_HORA,
 administracaoxitemxprescricao.DT_DATA, year(prescricoes.DT_PRESCRICAO) as data_prescricao
 FROM administracaoxitemxprescricao 
 join prescricoes ON prescricoes.CD_PRESCRICAO = administracaoxitemxprescricao.CD_PRESCRICAO
 WHERE administracaoxitemxprescricao.CD_USUARIO = 1 

[ViktorV]

To protect your data, you can use data encryption. MyDAC supports data encryption using the TMyEncryptor component. Take into account, that this component is available only in Professional and Trial Editions. See more details about data encryption in the MyDAC documentation: https://www.devart.com/mydac/docs/encryption.htm