Questions tagged [mysql-workbench]
A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.
0
votes
0answers
8 views
Error: The user specified as a definer ('Admin'@'%') does not exist
Error de SQL (1449): The user specified as a definer ('Admin'@'%') does not exist
I have this error when I'm trying to update a table. I don't know what I must do, because this error only happens ...
0
votes
0answers
12 views
What's the formula for calculating Key Efficiency in MySql? [duplicate]
How to calculate Key Efficiency percentage in MySql
0
votes
5answers
32 views
Mysql: Unable to drop a columns NULL default
Running mariadb 10.3
I have a bunch of columns that were created by default as NULL defaults. I was asked by a third party integrator to remove the NULL defaults, but so far have been unsuccessful.
...
0
votes
0answers
29 views
Need to know if my first database diagram is good [closed]
I read about database diagram and normalization, So I have managed to follow the normalization rules. But I am not sure if this is right or not ?
What my database should do:
I want to add posts ...
0
votes
1answer
26 views
Unable to export 8.0.1 MySQL database using MySQL Workbench 8.0
I'm unable to export my 8.0.1 MySQL database using MySQL Workbench 8.0. When I go to perform the export via the "Administration" table, with all the default settings (I didn't change anything ...
0
votes
1answer
29 views
mySQL Workbench new Connection : There is no disk in drive. Please insert disk in \Device\Harddisk2\DR2
I'm trying to migrate the data at my company from Excel to mySQL so I'm very new at this. I just installed the latest mySQL package via the standard installer and when I try a new connection (I'm ...
-1
votes
1answer
30 views
Select rows with same Name and their posible ID (could be Null)
So I have this
For every username there is at most one unique associated not null col2 value and potentially some null col2 values.
+----------+-------+
| username | col2 |
+----------+-------+
| a ...
0
votes
1answer
32 views
Error parsing DDL for schema.table in mysql workbench
I have production dbs using Mysql 5.5.31-0ubuntu0.12.04-1 (I know its old, will be upgraded soon).
I used a too advanced version of mysql workbench which allowed me to add a comment to key. (Now ...
1
vote
1answer
26 views
Error 2013 in MySQL Workbench when I perform any operation on a certain table
when using mysql workbench I perform any operation on the table "my_table" I get an error:
Error Code: 2013 Lost connection to MySQL server during query
Previously I stopped the execution of a ...
0
votes
1answer
9 views
Setting model title in MySQL Workbench for Forward Engineering
In MySQL Workbench, when viewing a model, you can select File->Export->Forward Engineer SQL Create Script.
The first four lines of the generated file are a comment, something like this:
-- ...
2
votes
1answer
40 views
find 16,000 words and replace with ##
I need to do a find a replace but rather than find one word to replace with another I have about 16k words, so as an example; table 1 has two words apple,orange - table 2 has the contents of a book, i ...
1
vote
1answer
32 views
Error 1062: Duplicate entry 'mydb/regimes' for key 'name'
I am not an expert on databases but I'm modeling a database on mysqlworkbench 8.0.13 and when I try to run the script it breaks at this table(regimes). I can't figure out what KEY 'NAME' it is ...
0
votes
1answer
16 views
MySQL 8.0 - SELECT QUERY
Hi I am having trouble with building a select query command with my tables.
TABLE CUSTOMER
+-----------------+-----------------+--------------+
| customer_number | customer_status | order_status |
+-...
1
vote
0answers
17 views
How to fully dump mySQL database via workbench?
I am exporting database in SQL file using workbench. Export is done successfully, but when I import data and compare record counts with older database, some of the records are missing. Not all records ...
0
votes
1answer
23 views
Which query execution will be faster
In the following queries, which query execution will be faster. When I tried executing them in SQLWorkbench, each time query execution time is varying.
Also, can you guys suggest some better tools ...
1
vote
2answers
54 views
Creating Multiple Tables with WITH statements
I have created Table1 and Table2 both with WITH statements. I have been trying to create Table3 with WITH statement as well that would be the UNION ALL of Table1 and Table2.
Here is my attempt:
...
-1
votes
2answers
62 views
Counting Occurrences of one Column in Multiple Columns in a Different Table
I have two tables, let's call them Table1 and Table2. Table1 has a column c1. and Table2 has two columns called c2 and c3.
I would like to count the occurrences of c1 from Table1 in both columns of ...
1
vote
1answer
1k views
Error during table creation : is not valid at this position expecting an identifier
I keeping getting this error during table creation: Order is not valid at this position expecting an identifier. I look up on the Web but I can't figure out how to fix this. What that error means, and ...
3
votes
1answer
135 views
Normalizing/combing mutliple tables with similar data
I'm working on setting up a database of vehicle records based on data from a third party vendor. There are 3 models: Vehicles, Transmissions, and Adaptors.
Both Vehicles and Transmissions are 1:n ...
0
votes
3answers
89 views
MYSQL 8.0 server not found in Workbench directory in Windows 10?
I have upgraded my workbench to 8.0CE and also removed the previous 5.7 MYSQL server as well as Workbench 6.3.
This is the directory:
C:\Program Files\MySQL\MySQL Workbench 8.0 CE
Also when I typed ...
0
votes
1answer
21 views
Analyze general log
Motivation : understand the highest CPU\usage\long_query of historic queries running on production.
example :10 minute ago on server x graph showed high CPU usage.
I thougth for next steps :
...
-1
votes
2answers
48 views
MySQL Query can we count rows using php to reduce time of count(*) in a query or there is no difference?
Having the following queries, where the first query is returning a field of number of rows found, and the second returns the actual rows:
First Query:
SELECT count(*) as total FROM individual i ...
0
votes
1answer
24 views
Crash of VMWare Workstation when generating EER Diagram
I'm facing an issue when I'm generating an EER diagram with MySQL Workbench 8.0
I'm using MySQL Workbench on a local Windows 10 virtual machine. My VM is running with VMWare Workstation 12.5.0.
I ...
0
votes
1answer
346 views
Problem creating my first database , annoying error
I created two tables:
person (id as pk , person and purchase)
user (id as pk , other columns not relevant to question).
After linking the two with an n:m relationship, and proceeding to forward ...
0
votes
1answer
511 views
New tables not showing up in MySQL Workbench Navigator [closed]
I've created a database on a local MySQL server with MySQL Workbench version 8.0 on Windows 10, but when I make a table in said database with a manually typed query
CREATE TABLE newtable (column1 ...
0
votes
1answer
370 views
Workbench freezes on connecting after Ubuntu 18.04 upgrade
I recently upgraded to Ubuntu 18.04 and started having this issue, I can connect to my local mysql server via the terminal fine using
mysql -u root -p
however when I try to use mysql workbench it ...
2
votes
1answer
189 views
Do you know if this are examples of non-identifying or identifying relationships?
Im using MySQLWorkbench to model a diagram. But Im with some doubts about identifying and non-identifying relationships. It seems that all relationships of the project are identifying.
For example, a ...
1
vote
1answer
66 views
DBForge can't connect with MySQL server, server is running
I recently installed the latest version of MySQL Server.
I initialized it with --initialize-insecure so I have a "root" user with no password set.
The server is running, with the command mysqld --...
2
votes
1answer
274 views
MySQL Workbench Visual Explain not working with MariaDB 10.3.9
I recently installed MySQL Workbench 8.0.12 and MariaDB 10.3.9. I created my database and want to start fine tuning indexes and views. I can run a query with the EXPLAIN button and get the results in ...
1
vote
1answer
224 views
getting innodb buffer usage
I am running MySQL 5.5.52 I am trying to see how much of my innodb buffer pool is used. If I run 'show engine innodb status' I see this:
----------------------
BUFFER POOL AND MEMORY
-----------------...
0
votes
1answer
140 views
Problems during migration from SQL Server to MySQL via MySQL Workbench
We've found most of the options we needed to include the necessary CHARSET. Here is what we've included in the MySQL my.cnf:
[client]
default-character-set = utf8mb4
[mysql]
default-character-set ...
0
votes
0answers
678 views
MySQL: ROW_NUMBER() OVER PARTITION Question
I am looking to essentially recreate the ROW_NUMBER() OVER PARTITION function that I have used in SQL Server Management Studio previously to do the following in MySQL. MySQL doesn't seem to want to ...
0
votes
0answers
24 views
MySql Workbench Syncronization does not completely sync the database
I'm using MySql Workbench and Wamp Server on my local computer.
I designed a model and syncronised it with "Synchronize Model..." in "Database" menu.
It completed successfully but when I trying to ...
1
vote
1answer
267 views
Why MySQL Workbench creates more than two foreign keys for many to many relations?
I'm using MySQL Workbench. I know that an additional table is needed to define a many to many relation. But why sometimes workbench creates this table with more than two foreign keys?
Is it added ...
0
votes
1answer
710 views
How to see special characters in MySQL Workbench query results?
In my Database, I made a small mistake by inserting a blank (space character) after a value like this:
INSERT INTO MYTABLE(country_name, code, value) values ('France', 'FR ', 345); -- id is ...
0
votes
1answer
397 views
MySQL Workbench Unable to Connect to Azure Databases for MySQL
When trying to connect to a MySQL database in Azure I get the following error:
ERROR 2026: SSL connection error: socket layer receive error
At first I thought it was a firewall/security issue but ...
0
votes
1answer
83 views
MYSQL - How to make a table with a column that will sum columns from parent tables?
I have a table called FOODS. FOODS has two foreign keys: IDsize and IDflavor.
The parent tables FLAVOR and SIZE each have a column price.
The table FLAVOR has columns IDflavor, flavor and price with ...
0
votes
0answers
20 views
How to debug difference in command line and work bench out put for MySQL?
I am supposed to create an automated CSV report from our MySQL database. For this purpose I have a standard script from here
mysql -u $USER -h $DBSERVER -p $PASS $DB -B -T -e "source myscript.sql" | ...
0
votes
0answers
134 views
Error 1317.An error occurred while attempting to create the directory MySQL
I'm trying to install MySql workbench but during the installation, an error pops out and the installation rolls back.
Error 1317.An error occurred while attempting to create the directory MySQL
C:\...
0
votes
1answer
193 views
Why is my SQL statement sometimes slow and sometimes fast?
I'm using MySQL version 5.5.45 on Windows Server 2016. I'm executing the following statement in MySQL Workbench version 6.3.
delete FROM childattendance WHERE date < DATE_SUB(NOW(),INTERVAL 2 ...
0
votes
1answer
378 views
MySQL Workbench is adding --enable-cleartext-plugin option on mysqldump command
For some reason my copy of MySQL Workbench on one of my servers has started adding this --enable-cleartext-plugin option on every mysqldump command, which results in this error every time.
20:13:02 ...
0
votes
1answer
30 views
Why is MySQL Workbench is reporting different number of writes per second at the same time on the same database?
I am working on a project with MySQL Workbench on a server that I remote into with Windows remote desktop. Sometimes I will also connect to the server with MySQL Workbench on my local machine.
When I ...
0
votes
1answer
248 views
MySQL Workbench Administrator - GUI root “Access denied” gotcha
Here is a small newbie problem I found and resolved. The behavior of the GUI is a little confusing so I figure I will share.
Running some Java examples, I have MySQL set up on Windows. After making ...
0
votes
1answer
295 views
How do I change where database diagram relationship lines attach in MySQL Workbench?
Sometimes, MySQL Workbench makes some strange choices about where table relationship lines get attached. For example, two vertical lines would be better in the following:
For a while, these boxes (...
0
votes
0answers
89 views
what does quotechar mean in mysql while importing data?
Someone sent me a xlsx excel file and I opened it with excel and saved as csv with utf8 encoding.
I use mysql workbench import wizard to import an excel-made utf8 csv file to a database table. But ...
0
votes
1answer
76 views
COALESCE & SUM along with Join table are not calculation correct
I'm working on the Join table with union of 5 different table together
as i have written code for union all table and it working fine without join table
SELECT sku,
sum(units_ordered) ...
0
votes
0answers
43 views
How to take mysql backup more than 300 GB?
For Syncing mysql replication we need to take backup of master data more than 300 GB.Which is the best method for backup in this scenario ?
0
votes
0answers
50 views
Restoring LARGE MySQL Tables (3GB+) from .ibd, .frm
I am trying to restore two specific MySQL Tables, both which are over 3GB in size. I have been able to resort all my other tables using the CREATE TABLE SPACE, DISCARD TABLE SPACE etc commands.
...
0
votes
2answers
33 views
Getting repetition of same values multiple times while combining two queries
I wrote two queries in MySQL Workbench and combined them into a single query:
Select *
from
(
(select division.name,
date(meter_data.reading_date),
sum(meter_data....
3
votes
1answer
68 views
Stored procedure getting delayed more
Stored procedure and it is getting delayed. Taking nearly more than half an hour if I call the stored procedure in MySQL command line client. This procedure is to update values in two tables
drop ...
