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