1

Topic: To receive the folder list and files? To receive HASH a file?

1) Prompt, please, as in procedure MySQL (without PHP) to receive the list of all folders and their files, since the given folder.
M. There is any analog of such decision which is in MSSQL:

INSERT INTO TableFileDetails (FolderFileName, Depth, IsFile) EXEC master. xp_dirtree StartPath, 10,1

2) Prompt, please, as in procedure MySQL (without PHP) to receive HASH a file from the received file list
M. There is any analog of such decision which is in MSSQL:

SELECT @FILE_HASH=HASHBYTES (' MD5 ', @FileFromFolder)

2

Re: To receive the folder list and files? To receive HASH a file?

1) Is not present.
It is possible to try to write the UDF, but hardly it of that costs. To transfer the task on the client, to the same PHP easier.
2) Directly - it is impossible. It is possible to try through LOAD_FILE () , but with restrictions. Well or the UDF to write, besides.
As a whole MySQL it is not intended for the decision of such tasks. And to drag this functional in it looks the bad idea.