Geek Answers Handbook

Is it possible to confuse SQL code in MySQL?

I am trying to find a way to obfuscate SQL code in MySQL.

There is “wrapping” functionality in Oracle databases, but I haven’t found one. Some ideas?

The ultimate goal is that the client has some difficulties to understand the code.

+5
source share
2 answers

I think MySQL has no way to obfuscate code. You can encapsulate all the SQL query code by creating a MEMORABLE PROCEDURE , although not encapsulated, but at least your entire SQL query is not displayed when used inside your code (PHP, .Net, etc.).

+2
source

MySQL - , , , IF, ...

SELECT co1, co2, IF(3 > 18, co3, '') AS co3 FROM table INNER JOIN...

.. COUNT , , (, , "" ).

0

More articles:


All Articles