Questions tagged [mysql-workbench]
A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.
465
questions
0
votes
0answers
34 views
Write the SQL code that will list only once the Physician-Person appointments
Write the SQL code that will list only once the Physician-Person appointments. In other words it will not list twice an appointment between the same physician and person
Can someone help me solve this ...
-5
votes
1answer
27 views
Write the SQL code to find the average charge by the family medicine physicians
We need to write the script to find the average charge of physicians who specialize in "family medicine.
But i'm confused on how to write this because when we look at the appointment table, where ...
1
vote
0answers
17 views
is there a way to dump schema tables that don't exist and ignore the ones that exist?
I am using this command to dump schema directly to a different server because the existing server don't have space left to dump the tables/schemas and then transfer to the other server:
mysqldump -h ...
0
votes
0answers
6 views
Hide information table in Mysql Workbench
is there any way to hide the table information subcolumn in mysql workbench?
I work with version 8.0
Thank you very much in advance.
0
votes
1answer
25 views
ola.hallengren - Alternative MySQL scripts!
Having worked with MS SQL for many years and found ola.hallengren scripts incredibly useful - I find my self in a MySQL environment.
Is there a MySQL alternative to ola.hallengren? - Perhaps someone ...
1
vote
1answer
64 views
Mysql Workbench 8 doesn't detect the my.ini file for my MySql 5.7 server. How can I point it to the correct file? [duplicate]
I upgraded MySql workbench to version 8.
I'm running MySql Server 5.7.
When I open the options file in workbench it says it cannot locate a file for MySql 8 and that it will create one in the path C:\...
0
votes
2answers
61 views
MySQL server will not start/stop
I am currently in the process of setting up a database in MySQL for an application where I will be running PowerBI to do analyses on the data in the database and in a further stage to design an ...
0
votes
1answer
76 views
Why do I have to set MySQL user password with mysql_native_password to connect with Workbench?
I've noticed if I set the mysql user's password like below, I cannot connect with MySQL Workbench.
ALTER USER 'root'@'localhost' IDENTIFIED BY 'myPassword'
If I use this below I can connect to it:
...
0
votes
1answer
27 views
Handling the foreign keys in data entry
I have two tables (Order and equipment) and they should be linked together by the order No. the SQL script is as the following:
-- -----------------------------------------------------
-- Table `rr`.`...
1
vote
1answer
30 views
MySQL Workbench shows running query but query not in process list [closed]
I am having an issue where the same query sometimes completes in 600 seconds or less, but sometimes lags for multiple hours. MySQL Workbench shows the query as 'Running...', and initially I can see ...
1
vote
2answers
146 views
Creating a table with CHECK constraints in MySql workbench
I created a table ORDER using Mysql Workbench as follows:
CREATE TABLE IF NOT EXISTS `rr`.`ORDER` (
`Order No.` INT UNSIGNED NOT NULL COMMENT 'The order of the inspected equipment',
`Order_Type` ...
1
vote
2answers
35 views
Can I use older MySQL workbench with newest MySQL server?
MySQL newbie here.
I'm using Ubuntu 16.04 (64-bit).
I've successfully installed MySQL Community Server 5.7 and MySQL Community Workbench 6.3.
Unable to find these answers in the MySQL forums. I've ...
0
votes
2answers
108 views
Debugging mode in MySQL Workbench
When running queries in MySQL workbench, some of them are captured to the log file at either:
MySQL/Workbench/logs
MySQL/Workbench/sql_history
However, I'd like to see ALL the possible queries that ...
0
votes
1answer
12 views
How to pull high-level server information from Mysql
MySQL workbench shows the following under server stats:
I know it can grab the Connection Name and the Port from the data that I'm using to connect, but where does it grab the Host, socket, Version, ...
0
votes
0answers
16 views
MySQL workbench Client Connection info
I have two mysql installations, one local and one on Amazon RDS. On my local, I can view info on the queries in the Client Connections section:
However, in the RDS connection it does not allow me to ...
1
vote
0answers
2k views
MySQL 8.0 - Could not acquire management access - Administration issue
I am using MySQL Workbench for many months, it was working fine. Today, when I tried to open Server Status in the MANAGEMENT tab, below error occurred.
MYSQL80 and Windows Management Instrumentation ...
2
votes
1answer
133 views
Incorrect relationships formed in EER diagram by reverse engineering the database script
I have a database with 6 tables. I tried to view the relationships between the tables by using EER diagram. I observed that all the one-to-one relationships were converted into one-to-many ...
0
votes
0answers
19 views
MySQL Workbench - Searching for column in query result
I'm using MySQL Workbench and I have a query result with hundreds of columns within it.
Is there a way to search/go to a specific column within the query result (Using the MySQL Workbench interface)?
...
2
votes
1answer
86 views
why am I getting a warning of Depreciation of INT(11) in latest version of MySQL?
When I try to create a table with a column of type INT, it automatically gets allocated as INT(11) and this Int length will get depreciated in the latest version of MySQL. How can I declare the column ...
0
votes
0answers
54 views
MySQL Workbench Schema tables are missing
just started exploring MySQL Workbench and I recently restarted MySQL Workbench and I couldn't find the table in the model. I believe it's still there but I'm not sure how to display it like before. ...
0
votes
0answers
15 views
after update triggers in mysql
I have 4 tables comment,employee,mode and module(all are default NULL).
I want to add an after update trigger in my comment table when emp_id,mode_id,module_id from comment table(which are foreign key ...
0
votes
1answer
88 views
mysql 8 datetime default throwing and error when forward engineering
I am trying to create a schema by forward engineering a model eer diagram. But its giving an error on the datetime fields when using the default current_timestamp which is allowed in mysql 8 for ...
0
votes
1answer
34 views
Stored procedure not displaying data when null is passed into input parameter
I recently started learning stored procedures in MySQL and created a procedure like this:
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_getAllDetails`(IN _student_no INT,
IN _class_id INT, IN ...
-1
votes
1answer
100 views
MySQL Query Fetch Time increases when LEFT JOIN with big table [closed]
I am fetching the same amount of data with 2 different queries. However, one of them have a fetching time of ~x130 compared to the other. Being the only difference between the two queries a LEFT JOIN ...
0
votes
1answer
27 views
MYSQL+MyISAM+Need information regarding check table statement
The MySQL CHECK TABLE statement checks a table or tables for errors.
Does the statement put an auto lock on a table before checking table for errors?
Does the statement perform a READ ONLY operation?
...
1
vote
0answers
182 views
Migration from Postgres to MySQL using MySQL Workbench (Error in Reverse Engineering catalog. A task has failed while execution)
When I am trying to migrate database from Postgres to Mysql, I am facing an error in the Reverse engineering source step in which the log shows
Starting...
Connect to source DBMS...
- Connecting...
...
1
vote
0answers
31 views
MySQL - can connect via “reverse engineer” but not by double-clicking the connection using the same connection info
A connection to MySQL Server on the same network fails when double-clicking the connection in MySQL Workbench (i.e. trying to connect the standard way). It gives the error message:
"Cannot ...
0
votes
0answers
31 views
Migration from Teradata to MYSQL over partition by
Working SQLs in Teradata
select row_number() over (partition by job_name, parent_job_name order by elapsed_sec) as rowno from schema.xyz
select min(elapsed_sec) over (partition by job_name, ...
0
votes
0answers
413 views
Attempted to import .csv into mySQL using workbench, but only imports 7 rows?
To start, I'm still a relative SQL noob so this question could have an obvious answer that I'm just missing. I'm trying to start a big practice project in my spare time using a dataset which has ~...
0
votes
1answer
36 views
Change default timezone to America Pacific
SELECT @@GLOBAL.time_zone, @@SESSION.time_zone;
Result: SYSTEM SYSTEM
SELECT CURRENT_TIME;
Result: 06:25:07
But MY System time is 11.55 AM IST and PST TIME is 11.25 PM
How can I change ...
0
votes
2answers
51 views
Issue with Auto increment in MYSQL
Current Structure in MYSQL:
CREATE TABLE `JOB_ONPREM` (
`JOB_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`JOB_NAME` varchar(255) NOT NULL DEFAULT '',
`SANDBOX` varchar(100) NOT NULL ...
1
vote
1answer
42 views
SQL Trigger that creates new table when a new record is added to current table
It's been quite a few years since I have done DB work. I am working through mysql workbench (using MS Access as a frontend).
I have a base table that I am multilinking (basically a name index type ...
0
votes
0answers
14 views
Storage fluctuates when creating a table as select from another table via python
My table "test_table2" holds around 12mil records and has 6 columns with small records (short strings, dates, etc.). The size of the table is cca 1 GB.
When I'm running this query:
create table db....
1
vote
1answer
3k views
MySql Workbench csv data import error
I' trying to import a csv file in MySql WorkBench but get an error:
Can't analyze file. Please, try to change encoding type. If that doesn't help, maybe the file is not: csv, or the file is empty. ...
0
votes
1answer
113 views
Obfuscate data during migration with MySQL Workbench
Is it possible to obfuscate sensible data during migration using MySQL Workbench?
We are going to work on site so we need to make a copy for develpment but the (MySQL) database contains sensible user ...
1
vote
1answer
34 views
MySQL - is there a way to implement a CHECK constraint after creating the table?
I created a table and after entering all the data, I found that I had missed a CHECK constraint in the CREATE TABLE statement.
create table jims_faculty
( fac_id int primary key,
fac_name varchar(15) ...
0
votes
1answer
158 views
MySQL Workbench Model sync sql_mode
Using MySQL Work Bench, When I look at the system variables of a server I am connected to, it shows the SQL_MODE as "no engine substitution"
When I open a Workbench Model, and use the "sync with any ...
0
votes
1answer
1k views
Unknown column in field list
Please help i dont know what i'm doing wrong.
CREATE DEFINER=`root`@`localhost` PROCEDURE `setState`(IN `statename` VARCHAR(100), IN `countryID` INT(11))
MODIFIES SQL DATA
BEGIN
SET @...
2
votes
2answers
646 views
Error Code: 1136. Column count doesn't match value count at row 1
I'm struggling here. This is my code
CREATE DEFINER=`****`@*****` PROCEDURE `setCountry`(
IN `countryname` VARCHAR(100) CHARSET utf8mb4,
IN `nationality` VARCHAR(100) CHARSET utf8mb4,
IN ...
1
vote
2answers
89 views
SQL case statement not executing else part
Problem statement:
Create a function to search a student with roll_no; if exists show "Student Name and Course" else show "Roll No not exist".
CREATE FUNCTION search(roll_num VARCHAR(50))
RETURNS ...
0
votes
2answers
1k views
Data truncation: Incorrect datetime value: '7/21/15' for column 'announced_on' at row 1
I am importing a flat file into a table in DBeaver v7.0.2. When I attempt to import, it's throwing an error for date field formatted as mm/dd/yy.
The date column in the table is defined with ...
0
votes
1answer
4k views
DBeaver: Access denied for user 'root'@'localhost' (using password: YES)
Context: I am creating a new Schema and looking to import .sql file generated from mysql dump. I have server running: MySQL 8.0.19.
I am using DBeaver client Version 7.0.2 and have setup a new MySQL ...
-1
votes
1answer
712 views
Problems with remote ssh access to mysql with Workbench MacOS
I am having problems connecting Workbench with Siteground.
All my connection settings are as instructed, however my question is do I have to open port 3306 on my Mac to connect to the Siteground ...
0
votes
1answer
206 views
Connection failed: No such file or directory Mysql - WSL
Sorry if i posted incorrect section.
I have Windows with this WSL:
PRETTY_NAME="Debian GNU/Linux 10 (buster)"
NAME="Debian GNU/Linux"
VERSION_ID="10"
VERSION="10 (buster)"
VERSION_CODENAME=buster
ID=...
-1
votes
1answer
2k views
Error Code: 1416. Cannot get geometry object from data you send to the GEOMETRY field
I am trying to run .sql file/import into MySQL database, however, I am running into Error Code: 1416. Cannot get geometry object from data you send to the GEOMETRY field .
Here's my code:
CREATE ...
0
votes
1answer
22 views
Where can I get a proper dataset for performing Normalization techniques? [closed]
I'm new to databases and I just started with learning different techniques of Data Warehousing. I was given an assignment to perform Normalization techniques on a dataset of at least 1000 rows with ...
0
votes
0answers
124 views
Importing csv file error 1059
I'm trying to import a csv file circa 30GB. I have a MySql server running remotely on a vm. When i try to import the csv file I receive the following error
is too long 1059
I'm using MySql ...
0
votes
1answer
438 views
Mysql import csv not complete by Mysql bench
I upload the csv file which has more than 5 thousand rows table data for option import wizard by Mysql Workbench. As the result the output table only 335 rows, have no idea how to overcome the ...
0
votes
1answer
75 views
mysql workbench can't write to sql history file
I'm running mysql workbench on my local machine, connected to a remote sql server.
I am able to apply changes to the database, however, I see this error every time I apply a change
I can't seem to ...
0
votes
1answer
62 views
Select rows from table having more than two specific values
I have a table having details such that
Userpin product Time1 contains
4556 23 7:30 A
4557 23 7:30 B
4558 23 7:30 C
...
