Am 03.12.2019 um 20:53 schrieb Wanderlei Huttel:
is there a way to decode the lstat field within MySQL? I found solutions
with PHP, perl, postgres but not with MySQL.
>
Yes, it's possible!
Take a look in the function "base64_decode_lstat" in my github:
You need to use this way:
SELECT base64_
Hello Helmut
Yes, it's possible!
Take a look in the function "base64_decode_lstat" in my github:
You need to use this way:
SELECT base64_decode_lstat(8,LStat) FROM File WHERE JobId=XXX;
https://github.com/wanderleihuttel/webacula/blob/master/install/MySql/update_tables_7.5.2_to_7.5.3.sh
Atenci
Hi,
is there a way to decode the lstat field within MySQL? I found solutions
with PHP, perl, postgres but not with MySQL.
I want to see the file size in a query, e.g. in the default #12:
# 12
:List Files for a selected JobId
*Enter JobId:
SELECT Path.Path,Filename.Name FROM File,Filename,Path W