-
Notifications
You must be signed in to change notification settings - Fork 0
/
README
43 lines (30 loc) · 1.33 KB
/
README
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
This UDF exposes some of the SQL parsing and validation routines of
MySQL to the outside world. It basically enables you to parse and validate
a query, without being executed (similar to prepared statements... maybe
we should have used those?? hmm...).
At the moment, only SELECT, CREATE TABLE, DROP and ALTER (partially) are
supported. Further options need to be implemented... Queries are parsed
as multi-queries.
UDF returns NULL if no error is found or the MySQL internal error message.
WARNING: IT COULD BE THAT THIS UDF HAS UNKNOWN SIDE EFFECTS ON YOUR SERVER!
IT COULD BRING THE SERVER TO A CRASH, OR WORSE, BLOW THE WHOLE THING UP!
YOU HAVE BEEN WARNED! WE DON'T TAKE ANY RESPONSIBILITY FOR THIS. IT IS YOUR
PROBLEM IF YOU JUST INGEST SOME RANDOM CODE FOUND ON THE INTERNET INTO A
SERVER DAEMON...
To install
----------
1) Download the mysql source corresponding to your installed
version. Building mysql from scratch is recommended.
Note: ONLY MYSQL VERSION 5.5 AND ABOVE ARE CURRENTLY
SUPPORTED
2) edit CMakeList.txt accordingly to point to the directory
where mysql is installed.
3) edit CMakeList.txt accordingly to point to the directory
of the mysql sources
4) mkdir build
cd build
5) cmake ..
6) make
7) make install
8) log into mysql server as root and execute the commands in
install_validateSQL.sql