Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [mysql-workbench]

A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.

Filter by
Sorted by
Tagged with
-1
votes
2answers
673 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
9k 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
217 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
1k 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
84 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
101 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
64 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
2k 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
2k 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
902 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
704 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
191 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 --...
3
votes
1answer
531 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
648 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
344 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 ...
2
votes
1answer
587 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
2k 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 ...
1
vote
1answer
802 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
307 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
26 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
1answer
447 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 ...
1
vote
1answer
1k 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
48 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
423 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 ...
1
vote
1answer
797 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
296 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
202 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
2answers
45 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
70 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 ...
3
votes
2answers
14k views

INSERT gives Error Code: 1366. Incorrect string value: '\xF0\x9F\x98\x80' for column

I am facing issues with my table structure : My_Table_Name1 CREATE TABLE `My_Table_Name1` ( `twitter_id_str` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `twitter_screen_name` varchar(...
2
votes
1answer
239 views

Suggestion for a contact management database design

I am currently designing a contact management database for a chamber of commerce. The goal of the database is to store all the person (except our own staff), all recorded companies (regular companies ...
1
vote
2answers
41 views

Stock Return as Zero due to unsold

At the moment I'm bit stuck and need advice, I have looked up the 'ifnull' but nothing I can find 'ifnull' along with join tables. SELECT Ifnull((SELECT tbl_sku_units_order.sku AS 'sold_sku',...
0
votes
1answer
2k views

Error Calling Python module function DbMySQLFE.connect

Migrating a database from SqlServer to Mysql using "MySQL WorkBench 6.3 CE" using ODBC data source as default methode to use to connect to the RDBMS. -> Source Selection Test connection is Successful ...
0
votes
1answer
16 views

Can I alter data within a mariadb db using mysql-workbench?

I am on Ubuntu, remote connecting to a point of sale. I want to update costs of ingredients on our menus. Can I do this in mysql-workbench?
0
votes
1answer
297 views

sql syntax error 1064 in workbench-generated script

I'm not very familiar with sql, so I'm using workbench to create a db. I keep getting this error: Executing SQL script in server ERROR: Error 1064: You have an error in your SQL syntax; check the ...
1
vote
4answers
9k views

MySql-Workbench: Can't connect to MySQL server on '127.0.0.1' (111)

The hard data first: Local machine: Xubuntu 17.10, with MySql-Workbench 6.3 Remote Machine: Ubuntu 16.04, with MySql-Client 5.7 and MySql-Server 5.7 The connection method is: Standard TCP/IP over ...
-1
votes
1answer
347 views

Unexplained MySQL behavior - SP returning wrong results (sometimes)

On an Ubuntu 16.04.4 LTS machine running MySQL (Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using EditLine wrapper) we are experiencing some very peculiar behavior. There is a schema, mydb, and two ...
0
votes
1answer
71 views

MySQL Queries to get only runtime/duration, not fetched results

We are running few benchmark queries against our test RDS instance for checking efficiency of partitioning, before adapting it to production, where there is no partitions presently. We have few ...
1
vote
0answers
767 views

Stored Procedures doesn't show up in MySQL WorkBench

I have a MySQL database which has a few stored procedures, functions, and tables. The problem I face is when I try to load the MySQL Database in MySQL WorkBench 6.3, it shows only Tables. Views, ...
-1
votes
1answer
2k views

Error Code: 1109. Unknown table 'revers' in field list

hello everyone this is a program to reverse a string the program works fine when values are given, but can't fetch the details from the table.If the method is wrong then please tell.thanking everyone ...
1
vote
0answers
119 views

Resetting MySQL Workbench 6.3 CE password

I'm a rookie using MySql Workbench 6.3 CE on Windows 10. Before I could even try to open my first data table to begin learning SQL, I've managed to forget my password. Can someone help me re-set it ...
0
votes
1answer
4k views

Check (health) status of MySQL schema table

I have a large MySQL database which has around 1,500 tables and the file of the database is around 30GB. I would like to suggest me some ways to monitor the health of my database in overall and how i ...
1
vote
1answer
9k views

Mysql Workbench crashing when connecting

I have created an user i intend to give access to one db only. But when i try connecting with him, the program crashes. When i connect with the root user, it works. create user 'test'@'localhost'; ...
2
votes
1answer
31 views

MySQL - can't get the result of non-matching records

I am trying to get the result of a record which has a missing entry in the other table. I already tried using NOT IN and NOT EXIST but I cannot get the desired result. The output should be Kevin and ...
1
vote
0answers
260 views

Convert string to int unsigned

I am creating a procedure that will allow me to auto increment a primary key my way. They key has a structure of M or V followed by a number. The key for the table is defined as varchar(100). The ...
4
votes
3answers
1k views

How do I test if MySQL “require secure transport” is working?

I activated the checkbox named "require secure transport" in the options file, found in the MySQL Workbench. How do I know if MySQL "require secure transport" is working? Should I use command line at ...
1
vote
1answer
10k views

mysql workbench failed to connect at localhost:3306 with user root ssl connection error: ssl is required but the server doesn't support it [closed]

Not sure what the answers are, but I will say that I have not found the answers on how to make this work again. The keyword support makes me think that a payment is required for this feature, but I'm ...
1
vote
1answer
2k views

Modifying initial values for an AUTO_INCREMENT column

I am using MYSQL Workbench, and I have a table called Customer and have a primary key customer_id which has the INT data type and is auto incremented ("AI" in Workbench column specifications). This ...
0
votes
1answer
2k views

MYSQL Workbench Column Default/Expression

MYSQL Workbench Column Default/Expression What can be put in here, I see I can put in a default value for the field Can I also put mysql statements? Or is this just for default values? For a ...
0
votes
2answers
2k views

MySQL Workbench - Error Getting DDL Object (It doesn't exist?)

The problem started when a table, started not to fetch a single SELECT. It was only a SELECT * FROM table; and it started to run and never stopped. After several attempts, all of them failed, and then ...