We’re rewarding the question askers & reputations are being recalculated! Read more.

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
1answer
18 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
32 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 ...
2
votes
2answers
3k views

MySQL Workbench query tabs

I am trying MySQL Workbench 6.0 and when I execute a query the results are displayed with a tab called "Result 1". When I fire another query the same tab is reused, now named "Results 2". I found no ...
0
votes
0answers
11 views

Trying to load data into table with a state foreign key and won;t accept null [closed]

I have a name and address csz table with a foreign key from the state field to the state table. I am using mysql v8 and using mysql work bench import wizard to do the import. If I load a record with a ...
0
votes
1answer
445 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 ...
-2
votes
0answers
7 views
0
votes
2answers
134 views

MYSQL to other DB migration using MYSQL workbench

is it possible to migrate MYSQL to other database platform like MS SQL 2012 using the MYSQL workbench migration wizard?. Everywhere the only destination DB is MYSQL, the reverse process is not ...
-1
votes
1answer
346 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 ...
2
votes
1answer
238 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 ...
0
votes
0answers
8 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
1answer
337 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
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 ...
0
votes
1answer
294 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 ...
0
votes
0answers
12 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
23 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 ...
2
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(...
0
votes
1answer
228 views

how to Import MySql Dump file in MySQLWorkBench

I have a MySQL Dump file for few objects of a database and I have to import only one table from that file in MYSQL Work Bench. My question is How can I import a dump file in MySQL Work Bench for ...
1
vote
1answer
195 views

How can I import latitude and longitude data into a database using Mysql Workbench?

I am currently trying to get some latitude and longitude data to import into a database using the data import wizard in mysql workbench. the problem is that the floating point values that get ...
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
416 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
239 views

mysql database migration of schemas with updated data and structures

I am a newbie with MySQL database dumps and am currently trying to work with data migration between a source schema and a target schema. Assuming the source schema is defined by (...
0
votes
1answer
252 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
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
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
1answer
22 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 ...
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
795 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 ...
1
vote
0answers
32 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. ...
1
vote
2answers
278 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 ...
3
votes
2answers
5k views

Migrating from Oracle to MySQL via MySQL workbench: Table list is empty

MySQL workbench offers a migration tool that I'm using to migrate an Oracle database to MySQL. I'm using the migration wizard to migrate the complete Oracle schema to MySQL. I used that for the ...
0
votes
1answer
1k views

Workbench Error Code 1267 - utf8_unicode and utf8_general

I've recently just swapped all of a databases tables and columns to utf8_unicode_ci from the weird collection of about 3-5 different collations they were previously (don't ask... not my database) So, ...
2
votes
1answer
463 views

mysql workbench connection type tcp/ip over ssh with libpam-google-authenticator enabled

I'm attempting to connect to my MySQL Database using the Connection Method "Standard TCP/IP over SSH". I filled out all the SSH and MySQL connection details correctly, however I get the message: "...
1
vote
1answer
881 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 ...
1
vote
1answer
190 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 --...
0
votes
1answer
902 views

Cannot connect to Aurora RDS using workbench over ssh

I set up an environment on AWS that consists of a VPC with a private and public subnet following the instructions for Magento Quick Start: http://docs.aws.amazon.com/quickstart/latest/magento/...
0
votes
1answer
104 views

Why does this MySQL 5.6 stored procedure not compile with MySQL Workbench?

Why doesn't this MySQL 5.6 stored procedure compile with MySQL Workbench? CREATE PROCEDURE spDataLocationSetActive ( IN driveLetter varchar(1), IN active ...
0
votes
1answer
1k views

How to view the table structure in workbench in mysql database without quotes

I need to view the structure(i.e table scripts without quotes) of tabes from mysql work bench Thanks
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
66 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
56 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 ...
0
votes
1answer
201 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
1answer
989 views

SHOW CREATE PROCEDURE procedure_name not showing the procedure content

Hello I'm struggling with the Issue where i have to view the stored procedure content for that i have issue the command to get the name of the Procedure mysql> SHOW PROCEDURE STATUS; +-----+-------...
0
votes
1answer
243 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 ...
3
votes
2answers
8k views

MySQL Workbench copies Schema, but not data, from SQL Server 2008

I need to copy/migrate a database from MSSQL (SQL Server 2008) into MySQL. I am using the MySQL Workbench kit, and work through the process of the Migration. Each respective DB user has full access, ...
1
vote
0answers
29 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 ...
1
vote
2answers
55 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
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 ...
0
votes
0answers
9 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
21 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 ...