I tried to compare two schemas using “Compare and Report Differences in Catalogs” in MySQL Workbench and got a report with:

I am new to SQL
I was trying this assignment and wanted to calculate total duration of pandemic in months, for which I used DECLARE, but it shows error of not in valid position, what is the issue here?
I am using MySQL Workbench

In the MySQL command line client, I can set various flags like --verbose, --comments, and --force on launch that affect the behavior of my queries. How can I set these flags in a MySQL Workbench session?

I’m trying to get a specific set of results from a MySQL database. It’s easier to explain if I first show an simplified example database.

I am receiving this error when trying to import a .csv. I am new to SQL and no forums online where able to help. I am using the Table Data Import Wizard.

I’m building a store procedure that returns the lowest price of each product and show their respective store info and date. This SP should allow optional parameters for StoreCity and ProdType. I’m a bit stuck at the SELECT query.

CREATE TABLE employees (
employee_id INT,
first_name varchar (50),
last_name VARCHAR (50),
hourly_pay DECIMAL (5, 2),
hire_date DATE,
);
Here is a picture from the software

CREATE TABLE employees (
employee_id INT,
first_name varchar (50),
last_name VARCHAR (50),
hourly_pay DECIMAL (5, 2),
hire_date DATE,
);
Here is a picture from the software

I am using MY SQl and created a database containing 5 tables.

When I try to set datatype to int, it works but after I save it, it looks empty. So I can’t set any foreign key which has datatype int