In order to help my wife , I have the ambition to create a software that would exploit a mysql database and allow her to save time in her job.
The design part is fine but I'm terrible at join between tables and wondered if there was a visual tool that ideally would make join in my stead or at least help me a bit.
I do not have Microsoft or Apple license on any of my computers, so any Gnu/Linux solution would be ideal.
Any advice or suggestion?
OK I admit, my question is not very clear and English is not my first language , sorry if it seems a bit confuse .
Let's say my database is already designed and also I can make basic requests and get results, no problem for that.
Like I said before I really suck at join tables , I find it very tedious at best plus I'm quite dyslexic and it is very difficult for me not to confuse queries lines, especially when they are numerous and repetitive.A huge waste of time
What I look for is a tool able to create complex queries and especially joins , provided of course I gave it the export of the database I want to work with. As if I could see my tables, connect the rows I want to join with a thread, pull the thread and voilà, my request is made in a few clicks, I can copy/paste it for any purpose