Questions tagged [mysql-workbench]
A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.
408
questions
-1
votes
0answers
15 views
How to connect server in MySQL workbench [closed]
I'm tried any method. Even ash still failed to login server.
My server is installed Ubuntu with mysql. Still need additional configuration?
I tried to config my.cnf put 0.0.0.0 in IP bind but forbid ...
1
vote
1answer
55 views
MySQL Workbench, Windows Server 2019, MySQL not showing Performance, Information of MySQL Schemas!
This evening I installed MySQL on a new clean install of Windows 2019 server. When the install finished, the installer offered the possibility of opening Workbench so I said yes.
Then I noticed that ...
0
votes
1answer
37 views
Is it possible to run multiple versions of MySQL Workbench?
I'm doing an application migration from MySQL 5.5 to workbench v8... 5.5 supports MySQL Workbench up to version 6.3... However, MySQL server 5.5 only supports up to version 6.3 of the workbench.
I ...
-1
votes
1answer
23 views
Follow up to multiple result tabs in Workbench
@Mike Lischke -- this is in response to your reply to my question here regarding multiple result tabs (Multiple Result Tabs in Workbench)
This is a screenshot of the tutorial I am viewing to teach ...
0
votes
1answer
43 views
Multiple Result Tabs in Workbench
I have several queries in the editor, each terminating with a semi-colon (I am teaching myself SQL and so in the editor is a mix of queries and notes like below):
SELECT *
FROM orders
WHERE ...
0
votes
0answers
9 views
Syntax error when creating procedure in mysql
I am trying to create a procedure, but I am always getting syntax error and it is marking me "(" or ",". Iam using version 6.3. Can somebody help me to fix this problem? And here is my code
0
votes
0answers
16 views
prepared statement returns NULL, unable to retrieve the column value
I'm creating a procedure where it will iterate over every column in a table and get maximum value of every column. This is my code:
DELIMITER //
DROP PROCEDURE IF EXISTS min_max //
CREATE PROCEDURE ...
1
vote
2answers
25 views
ALTER TABLE DROP COLUMN - server status 'Stopped'
I am in the process of removing 4 columns from my (MySQL/innodb) table,
simple code,
ALTER TABLE database_name.table_name
DROP COLUMN A,
DROP COLUMN B,
DROP COLUMN C,
DROP COLUMN D;
It has been ...
0
votes
0answers
12 views
Import mysql tables and data into Sql server2008, when mysql is on a remote server and sql server 2008 is my local server
I am trying to import mysql tables and data (on a remote server), to sql server local database. I have exported data from mysql workbench and saved them as .txt and then imported flat text files into ...
0
votes
1answer
24 views
mysql workbench - Couldn't find option to remove DROP TABLE IF EXIST
Recently I've been looking into export options to find an option to remove:
DROP TABLE IF EXISTS and replace it with CREATE TABLE IF NOT EXISTS.
I've seen on other MySQL clients like HeidiSQL or ...
1
vote
0answers
40 views
Mysql Workbench generates an additional FK in child of a child table referencing the Parent of its Parent
I'm trying to create a Part that is a child of Sublot, which in turn is a child of Lot. Mysql Workbench automatically creates the foreign keys, when I insert the many-to-one relations graphically.
...
0
votes
1answer
88 views
Endless Query Loop In Mysql
I will delete millions records from a table in mysql dbms, but i don't want to delete all records at one time not to force database server cpu. That's why i want to use my query many times. My whille ...
1
vote
1answer
81 views
Latest MySQL version for Windows 7
How can find out which are the latest GA verions of MySQL Server & Workbench supported under Windows 7?
On the 'MySQL Product Support EOL Announcements' page it states:
Per the MySQL Support ...
1
vote
0answers
30 views
Unconnected tables for predefined options in MySQL DB [closed]
Is it okay to live some tables not connected to anything?
I have a table with a set of discounts for deals. For each deal, discounts can be summed up, so I don't see the point in connecting the "...
0
votes
1answer
32 views
What is a connection in MySQL Workbench?
I've searched so much and still found no answer to what exactly a connection is. I'm a beginner and don't know how connecting to databases/servers works, so I can't move forward yet.
What does the ...
0
votes
2answers
40 views
Does my database need to connect to a server? [closed]
I'm very new to SQL and databases. I'm currently following this tutorial for creating a Magento website: https://www.tutorialspoint.com/magento/magento_installation.htm
and I'm on Step 4. It says to ...
1
vote
2answers
78 views
Error 1005 when Forward Engineering EER diagram
I have created an EER diagram (as shown in the image bellow) in MySQL Workbench and wanted to Forward Engineer to build the DB.
After configuring the model options to the Target MySQL Version and ...
0
votes
0answers
11 views
How can I get the MySQL Workbench migration report in a file?
I am looking into a possible migration from SQL Server to MySQL. I've run the migration tool and generated a report but the output is HUGE and I need to share different parts of the report with ...
0
votes
0answers
22 views
How to find executed query by user
I want to find all the queries executed by an particular user in a database over a period of time in MYSQL. Even they executed query by using MYSQL workbench i want to see log in my Database cloud ...
0
votes
1answer
33 views
How to get dates from a table while the date range is from the date belonging to another table?
I have a table datedim which has all the dates of a month in it. I have another table attendance that has dates on which attendance were taken. I need to write a query where i can get all the dates ...
0
votes
1answer
22 views
Using MySQL Workbench 8 on RHEL7 gui - When I highlight text in the SQL editor it turns black
I'm assuming this is a config issue in MySQL Workbench or in RHEL.
How can I change this to a readable color?
0
votes
0answers
20 views
MYSQL need log executed query in table along with executed user name
I would to like the executed quires with entire database tables for some mysql users only. Because some of users executed wrong query in production environment. And needs to store this log in new ...
0
votes
0answers
309 views
MySql Workbench Couldn't find section mysqld in the remote config file /etc/mysql/my.cnf
if you get this trying to connect to your remote server using MySql Workbench, then try to (on your remote server) navigate to /etc/mysql/my.cnf
and add
[mysqld]
then it should look like:
!...
0
votes
0answers
181 views
How to improve the speed of a large data migration between SQL Server and MySQL server?
I have an application that is connected to a SQL Server Express database. The database grew and the database is almost at 10GB which is the max limit that SQL Server Express allows for.
I am trying ...
0
votes
0answers
49 views
Insert values into a table using a trigger with values from stored procedure
I'm a newbie here. So, please feel free to correct me if my code or thinking approach can be worked upon.
I am working in MySQL Workbench and MySQL 8.0 Command Line Client. I have a database called ...
0
votes
1answer
1k views
Is it possible to change the color of relationship lines in MySQL Workbench diagrams?
I have MySQL Workbench Community Edition 8.0.15 installed on my Mac OS 10.14.3. I'm currently working on making an ERD with Workbench's EER Diagram.
My problem is that whenever I export my diagram, ...
0
votes
0answers
99 views
How to restore the missing mysql db schema?
My DB schema is missing/deleted by someone without my knowledge from ASW EC2 windows machine. Seems some unauthorized user entered into the system illegally and did something. Since I can find some ...
0
votes
1answer
36 views
Why these Two Queries performace so different?
This is Query 1:
SELECT
A.innings_no AS Inn, bowler, OT.Out_Name AS OutType, Runs
FROM
(SELECT
a.innings_no, a.striker, SUM(b.runs_scored) AS Runs
FROM
ball_by_ball a
...
0
votes
0answers
295 views
Load From S3 MySQL Error Code 2013 — AWS Aurora
I am attempting to load S3 files to an Aurora MySQL DB Cluster using the below AWS documentation:
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.LoadFromS3.html
...
0
votes
0answers
22 views
one to many relation how to create a new row with mysql trigger
i'm really new to mysql triggers so...i have 3 tables: a,b and c. table a is related with table b with a one to many relaion and table c is the table that get the triggered infromation from the 2 ...
0
votes
0answers
242 views
mysql trigger before insert
How can i make this trigger update my table DATA if there is no row to update.
Until i insert data in other table lets called ABC, this table uses a after insert trigger to insert information into ...
1
vote
0answers
204 views
Received an unsupported type from Postgres. (14) (SQLGetData)
I have database in PostgreSQL. It is simplest possible database with schema presented here:
http://www.postgresqltutorial.com/postgresql-create-table/
I want to migrate it to MySQL. I trying to ...
0
votes
0answers
333 views
MySQL reporting version mismatch due to picking up previous installation
To solve a mysqldump "Workbench was unable to get mysqldump version. Please verify the log for more information.", I opted for the first solution at
https://stackoverflow.com/a/44851129/175241
But ...
0
votes
2answers
184 views
How to set all auto increments to 1 in a Schema
Is it possible to reset all auto increment in a schema in one query? if not even just by per table will do. btw I am using MySQL server 8 thanks in advance :)
0
votes
1answer
283 views
MySQL - Split results of count function into columns derived from a separate column
The title seems a bit confusing, but I am struggling to put down what I need this query to do so best to explain it. I have 3 tables in my database (Using MySQL Workbench), but for this query I'm just ...
0
votes
1answer
55 views
MySQL workbench can't deal with MariaDB's new Invisible columns
Recently upgraded to MariaDB 10.3 which has a new feature whereby we can create an invisible column like so:
ALTER TABLE MyTable ADD COLUMN `TestA` INT INVISIBLE;
But once I create this column, ...
0
votes
1answer
1k 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
14 views
What's the formula for calculating Key Efficiency in MySql? [duplicate]
How to calculate Key Efficiency percentage in MySql
0
votes
5answers
71 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
1answer
288 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 ...
1
vote
2answers
304 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
33 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
991 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
153 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
32 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
48 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
423 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
21 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
31 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
26 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 ...
