|
| Nee a hint : enumerate tables from mySQL |
| Iniciado por guest, 19,jul. 2018 20:37 - 5 respuestas |
| |
| | | |
|
| |
| Publicado el 19,julio 2018 - 20:37 |
Hi Forum,
I am trying to create something like hmodifystructure() myself to use it for mySQL.
No I wonder, wheather I can enumerate the physical files and their items on the Server.
Am I Right, that Hlistfile() lists the files of the Analysis?
Thanks for help.
Best Regards
Stefan. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2018 - 13:33 |
Hi Stefan
yes it does and you can then use hListItem
Another way of doing what you want is to use the SQL script generated by the analysis at each generation. That script is for CREATING the tables only, but you can massage it to do alter tables instead (I knew of one developer who coded that way to make a module for postgres)
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 21,julio 2018 - 00:48 |
Hi Fabrice,
thanks for your answer.
So, hlistfile() and hlistitem() read the Analysis, not he physical files, correct?
Does anyone has an idea how to list the phyical files?
Thanks and have a good night
Stefan. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 21,julio 2018 - 13:20 |
Hi Stefan,
yes, they both work against the analysis... For physical files, use flistfile or, in the case of an external SQL DB, use the SQL command available with that specific DB.
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,julio 2018 - 10:52 |
For the phyical files you must use the MYSQL views.
I don't know MYSQL but in other db engines you can use this:
select * from information_schema.tables
select * from information_schema.columns |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,julio 2018 - 18:43 |
Hi Fabrice and Paulo,
thanks a lot, thats what I needed |
| |
| |
| | | |
|
| | | | |
| | |
|