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

learn more… | top users | synonyms

0
votes
0answers
24 views

How to implement a query insert into BEFORE INSERT trigger syntax

I want to insert data using trigger into 2 tables. I want to implement my query insert to a before insert trigger. Since I was newbie for using MYSQL, I'm confused how to implement it. insert into ...
-1
votes
0answers
39 views

Create Procedure

CREATE PROCEDURE validateZuoraFormat ( IN client varchar(100)= ' ', IN table varchar(100)= NULL, IN type varchar(100) = NULL, IN debug bit = 0, IN clientReport bit = 0, ...
0
votes
1answer
16 views

Creating procedure in mysql [on hold]

I am trying to build a procedure that i would use to check my data format before processing it to the net stop and i need this procedure to check the format of my file. So what i need is, my database ...
0
votes
1answer
31 views

ERROR 1091 (42000): Can't DROP 'created_date'; check that column/key exists

mysql> alter table bill_item add index idx_comp(created_date,product_id); Query OK, 0 rows affected, 1 warning (1 min 2.62 sec) Records: 0 Duplicates: 0 Warnings: 1 Trying to drop the index: ...
0
votes
0answers
28 views

How to view the data from a .mysql file?

I have a .mysql database file. I need to open it and view the data. I've MySQL Server & MySQL Workbench installed into my Ubuntu 14.04. Now how do I open the .mysql file and view the data inside ...
2
votes
0answers
27 views

Getting error 1064 in automatically-generated code from MySQL workbench [duplicate]

I have started using mySQL workbench (Version 6.3.4.0) and I have used the EER Diagram tool to design a schema. So far, so good. However, when I try and run the Forward Engineering, I get the error ...
1
vote
0answers
33 views

Replicate existing database live

New to db admin here and I have a question. My setup is Windows Server 2012 R2, MySQL, using MySQL Workbench. I have Database A on Server A, how can I make an exact clone of this database (Database ...
3
votes
3answers
56 views

MySQL adds broken comment script after each line

Every time I try to create a table using MySQL Workbench 6.3 CE it adds "broken" comments at the end of the script. Example: I am trying to create a table called "user". This is what the table ...
3
votes
3answers
58 views

MySQL - Unable to Convert Primary Key to Auto Increment

I have a MySQL table where the Primary Key (int) was set by the software to be equal to the Primary Key (auto incremented) of the main table. Because of a change in design I now need the field to auto ...
0
votes
1answer
39 views

How to populate a table's foreign keys from other tables?

I have a database with the following tables: Airport ( iata PK, airport, city, state, country, lat, long) cancellation_cause ( cod_cancellation PK, description) Manufaturer (id_manufacturer PK, ...
0
votes
2answers
49 views

Create foreign key doesn't work, column types match

I'm trying to create a foreign key in mysql workbench, but keep getting this error: I've checked the columns on both tables, and they match up as well as I can make them. One is CHAR(21) not null ...
0
votes
1answer
17 views

Error 1241 When Calculating Percentages

I am trying to get my percentages to equal 100%. As of right now they far surpass 100%. I need to account for the percentages in two different tables, ua_money_allocation and ua_expenses_by_school. ...
1
vote
0answers
58 views

How to pass the value of PK to FK

Ok, so here it goes. I have a table called employee. then I have another table called languages. I need to copy the value of PK of employee table to foreign key in Languages table, rather than ...
0
votes
1answer
42 views

Is it possible to convert mssql to mysql?

I've mssql.sql file I need to convert to mysql schema. Any ideas how? I'm on mac, I guess my choice is very limited. Tried workbench but it asks me for a live server connection to mssql which I don't ...
1
vote
1answer
20 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
2answers
649 views

Missing “MSVCR120.dll” during the Installation of MySQL Workbend 6.3 CE

When I install MySQL Workbench 6.3 into my Windows 8.1, I encounter the following System Error : I already tried to redownload and reinstall the program but this error dialog appears every time. ...
2
votes
2answers
82 views

Problem with new MySQL Workbench connection

I'm working on Debian 8 and wanted to create database using MySQL Workbench. I did everything in this tutorial, but when I created a new MySQL Connection, the program returned: Failed to Connect ...
2
votes
2answers
33 views

Scheduling MySQL Workbench to execute and export on a daily basis

Here's my question. I have a couple scripts (very simple stuff; select queries) that I run in MySQL Workbench which I can than export to CSVs. What I want to know is if it is possible to schedule ...
0
votes
1answer
32 views

migrate MySQL database with MySQL Workbench CE failed on table with blob data

I am using MySQL Workbench CE to migrate one schema from a server to another, all table is migrated successfully, except one table with blob data. The error message is : Found record bigger than ...
0
votes
1answer
269 views

No connection could be made because the target machine actively refused it. MYSQL work bench?

I have created php and Mysql site.Its Working Locally Xampp well. Finally I moved My site to server..i have Used Mysql Workbench. connected client database in Mysql Workbench in My system.when I Run ...
0
votes
2answers
236 views

No connection could be made because the target machine actively refused it

I have created a PHP site using MySQL. It works well on localhost. However, when I moved it to a remote server, it stopped working. The error shown is: "No connection could be made because the ...
0
votes
2answers
71 views

Is it redundant to set your primary key as a unique key?

I'm putting tables together in MySQL workbench and I'm currently ticking my primary keys to also be uniquely indexed. Is this a redundant configuration?
2
votes
1answer
48 views

MySQL Workbench team strategy

I'm considering to use MySQL Workbench at work, mainly because of the modelling tools and to easily sync the development and the production DBs. I work with another developer on the same project, and ...
0
votes
1answer
277 views

Is it possible to change ER diagram style in MySQL Workbench? How?

I am really new to database visualization. I am creating the ER diagram of my databases. I am using MySQL Workbench 6.3 (community version). I am creating the diagram using the default style. The ...
0
votes
1answer
57 views

How do I recreate a table that was deleted during an ALTER statement (errno: -1)?

For the third time in the past 2-3 weeks I've gotten the following message during an ALTER statement: Error 2013: Lost connection to MySQL server during query SQL Statement: ALTER TABLE ...
0
votes
0answers
112 views

PostgreSQL -> MySQL Migration with MySQLWorkbench

I'm trying to migrate data from a PostgreSQL DB to a MySQL DB (it's for permissions in the VPC, so please nobody link me the 'choose-something-else'). I'm getting this error from MySQL Workbench when ...
0
votes
0answers
51 views

MySQL Workbench error: Attribute error 'nonetype' object has no attribute 'parameterValues'

I am trying to export a database but i don't have access to "server administrator" at all... everytime i try to do something from Server administration i get the message mentioned in the title. What ...
0
votes
0answers
35 views

table design approach for a rental application with several one to many relationships

I'm trying to go about designing a database/tables for the following situation I'm being presented. I'm developing a rental web application with MySQL as db engine. It is for a nonprofit organizations ...
1
vote
3answers
28 views

Optimizing MySQL query with left joins

Ok, so first off i am going to provide a bit of information on the database structure I have 3 indexed tables that are used in this query (though one of them should probably be a weak entity, but ...
1
vote
1answer
93 views

Getting Data Type ID in MySQL

So, In SQL, We have the following query to find the system data type ID of columns in SQL Server; select name, system_type_id from sys.columns where object_id = OBJECT_ID(N'sometable') It gives the ...
1
vote
1answer
55 views

MySQL schema recovery

Is there a chance to recover overwritten schema or table in a schema? I have accidentally overwritten schema with the back-up from other source.
1
vote
2answers
41 views

How to define partition according to Date?

I am currently using MySQL 5.6. In my database, I have a log table called paramlog_ems. It has 2M rows I want like to partition this log table according to Date. Here is the table structure: ...
1
vote
1answer
172 views

Correct 'lines terminated by' for query

I am trying to query two tables of data and send them to a csv file for upload to a website. However i am having trouble getting the formatting to play ball. I want headings to separate into columns ...
0
votes
1answer
55 views

MySQL Workbench: “Operation has completed with warnings”

As I synchronize my database, MySQL Workbench reports: "Operation has completed with warning. Please see logs for details." But the Message Log just says: Fetching schema list. OK WARNING: ...
0
votes
2answers
51 views

How to create function using another functions mysql

I want to create a function in MySQL using another function but I am getting an error "Explicit or implicit commit is not allowed in stored function or trigger". This is my code: DELIMITER $$ ...
2
votes
1answer
50 views

Querying MySQL and SQL Server from same IDE

I am currently working with MySQL and SQL Server. For querying MySQL I use MySQL Workbench, for SQL Server I use SQL Server Management Studio. I am mixing up shortcuts all the time. For instance, ...
0
votes
0answers
31 views

Foreign keys in MySQL Workbench

I am defining an EER model in MySQL Workbench. I have a library with multiple copies of each book and each book has its location in the library listed in the system. When I'm creating one-to-many ...
1
vote
1answer
79 views

Data normalization (from 0NF to 1NF)

I am designing a relational database in mySQL - a library management system. I want to show examples of the data in 1NF, 2NF, 3NF, BCNF, etc. My example of 1NF looks something like this "A relation ...
0
votes
1answer
23 views

Mysql Adding date/time stamp to file produced, or other method of automated file naming to keep resulting files unique

SELECT '"Part #"', '"Manu"', '"Qty"', '"partdesc"', '"Rohs status"' UNION all ( SELECT partno, manuf, qtyleft, partdesc, stfifo.ROHScompliance FROM stmaster, stfifo WHERE ...
1
vote
0answers
87 views

MySQL workbench won't import my sql file

I have an SQL file im trying to import via mysqlworkbench but I keep getting the error: Access denied for user 'wordpressuser79'@'localhost' (using password: NO) Operation failed with exitcode 1 ...
1
vote
2answers
216 views

MySQL unknown column 'password_last_changed'

When creating a user using this command create user 'foo'@localhost'; this error is shown ERROR 1054 (42S22): Unknown column 'password_last_changed' in 'mysql.user' Using MySQL server version: ...
0
votes
1answer
67 views

middle table in one-to-many relationships

I just started using mysql workbench but it is slightly from the er diagram that i design in paper. I want to have a 1 to many relationship with three tables. For example a have entity A and entity B ...
1
vote
1answer
155 views

How we resolve Mysql Enterprise online backup error with “CORRUPT LOG RECORD FOUND” log error

I have configured my production MySQL database with MySQL Enterprise "online Backup" option. The configuration was went through successfully. When the assigned scheduler is try to take backup then i ...
1
vote
2answers
61 views

MySQL Workbench: How to detach reverse-engineered EER diagram from existing database?

MySQL Workbench provides the option to 'Create EER Model From Existing Database'. Trying to remove a table from the resulting diagram leads to a dialog asking: Should corresponding database ...
0
votes
0answers
9 views

Is it possible to ADD 2 EER model from 2 differents database in the same editor screen in MySQL Workbench?

I am using MySQL workbench to visualize a EER model form one database, lets says db1. It is a 166 tables database. Then I have another database, that interacts with db1, that has 10 tables. So I have ...
-2
votes
2answers
69 views

How to interract with my database? [closed]

I am generally new to Databases, and I have a MySQL server with several tables which have a unique ID that is connecting them all. I am about to populate the db with data from external resources ...
2
votes
1answer
79 views

Why MySQL Workbench automatically sets NOT NULL for ID column that is PRIMARY KEY?

My question is why MySQL Workbench automatically sets NOT NULL for ID column that is PRIMARY KEY? I thought that PRIMARY KEY's can't be NOT NULL by definition? Is it really necessary to set it to NOT ...
1
vote
2answers
777 views

MySQL Workbench not showing stored procedures that I have created

I have a simple stored procedure that I have just created. I have applied this script to my database This script shows up in the my list of stored procedure However, when I restart MySQL ...
1
vote
0answers
48 views

Get unique rows based on max of a column in mysql

I came across many solutions like the one in this question. However, they all are restricted to data from one table. I'm very very new to SQL. I'd like to get the same results as in the linked ...
0
votes
0answers
355 views

ClearDB Granting Created User Access

I added the ClearDB addon to Heroku, but upon using the created username to create a new database, the error appeared: Executing: CREATE SCHEMA `androidchatterdatabase` DEFAULT CHARACTER SET utf8 ; ...