I’m beginning my journey to learn SQL.
For some reason when I run a query go to the Execution Plan and try to switch to Visual Explain it won’t work and stay on the Tabular Explain.
I’ve downloaded the most recent version of the MySQL Workbench (Currently 8.0 CE)
Is there a quick fix for this situation or something else needed to be configured or installed?

this is the query in mysql

DELIMITER $$ CREATE PROCEDURE ifconditionerror( IN emplyee_id INT, IN employee_name VARCHAR(200), FLAG TINYINT) BEGIN IF FLAG = 1 THEN INSERT INTO EMPLOYEES (id, name) VALUES (emplyee_id , employee_name); ELSE SET MESSAGE_TEXT = ‘Data already exists’; END IF; END $$ DELIMITER ; I want mysql query in this one row data is there it will show […]

Apple M1 Pro (OSX 14.5)

I understand that this may be a stupid question xD
I have a database on MySql Workbench, but I don’t understand how to make an interface for it for editing (adding and deleting data) and displaying one of the tables of this database.

I have this Connection Warning error “Incompatible/nonstandard server version or connection protocol detected (8.4.0).” when testing connection for a new user I created on mySQL workbench. I think it is because I downloaded the LTS 8.4.0 version of mySQL the first time. so I uninstalled and redownloaded the 8.0 version but the issue still persist. How do I get workbench to work with the 8.0 version?

whenever i try to use and open MySQL Workbench i always get this warning/pop up ;Incompatible/nonstandard server version or connection protocol detected (8.4.0).

command–>

enter image description here
Options of adding new table and adding relation between table is missing. I have reinstall it several times but still having same issue.

I am using mysql workbench 8.0.36. I am trying to create a new table and populate it with data from a CSV file. I keep getting error code 1290 –secure-file-priv option issue. I’ve relocated my CSV file to the Uploads folder in MySQL and keep getting this error. I have seen threads here, and elsewhere, with suggestions about changing settings and whatnot, but none of them are resonating. If I put the file in the secure Uploads folder and am referencing it correctly as ‘C:/ProgramData/MySQL/MySQLServer 8.2/Uploads/Myfile.csv’ and keep getting the error. I also tried ‘C:ProgramDataMySQLMySQLServer 8.2UploadsMyfile.csv’ and get the same error. I’ve seen someting about changing my.ini but that is the part I get incredibly lost on. I’ve spent quite a bit of time on this project and I just need this issue solve so I can move forward. Thanks for any help