If not, the error code can be looked up to get more info about what's wrong. Once the error codes are visible, one can sometimes fix the problem from the attached explanation alone. If statement results do not appear, one needs to get the horizontal divider at the top of the Output Area and drag it up so there's enough space to see the error codes. The Output Area appears at the bottom right of the WorkBench screen. If it says the former then the area is currently hidden, so one needs to click the 'Show Output Area' option and it will appear. One first needs to check that the Output Area is not deliberately hidden, by doing menu actions: View > Panels > and looking whether it says Hide Output Area or Show Output Area. For some reason when I first loaded it, the Output area was condensed down to just a heading, with no room to see the lines describing the result of each statement, and error codes when applicable. I realise the problem was just that the Output Area was not visible on my WorkBench screen. I wanted a GUI that would also let me browse the tables, and highlight syntax errors in the code editing window, and thought that WorkBench would be the tool to do that, but it looks like it might be aimed at doing much more than that, and may be an unnecessarily complex environment for what I'm trying to do.ĭ'oh. The docn spends a lot of time talking about forward and reverse engineering and models, and I think I've got the general idea of what that is, but all I want to do is read in tables from csv files, manipulate and analyse them, then write out some result tables. I'm starting to wonder whether WorkBench is not the best tool for this type of activity aimed at developing sql query skills. If the best solution is to use something other than WorkBench I'm quite open to that. On windows I just get a white cross on a red circle telling me there's an error and that I need to correct my code. In WorkBench 6.0 on linux all I get is a 'Query Interrupted' message. In both cases no info is provided about why the query failed. I am also using it on the same PC (dual-boot) on windows 7, although I don't know the windows WorkBench version right now because I'm writing this from linux. I am using WorkBench 6.0 on linux mint Rebecca.
#Mysql workbench linux software#
Is there any way to get more helpful information about what problem the software detected that caused it to raise the error message? When a query fails the only message I get is one telling me it failed because of an error.
#Mysql workbench linux how to#
How to update Uninstall or Remove Workbench Steps to install MySQL Workbench on Rocky Linux AlmaLinux 8 1. Install MySQL Workbench on Almalinux 8 Rocky Linux 8 5. I have loaded MySQL and MySQL workbench on my PC, and am using it to build up my SQL skills, accessing only data stored on and served by the PC itself. Steps to install MySQL Workbench on Rocky Linux AlmaLinux 8 1.
0 kommentar(er)
