Top "Mysql-workbench" questions

MySQL Workbench is a visual database design tool that is developed by MySQL.

Errno 121, duplicate key on write or update?

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @…

mysql mysql-workbench workbench
How to disable column-statistics in MySQL 8 permanently?

Since MySQL 8 the column-statistics flag is enabled by default. So if you try to dump some tables with MySQL Workbench 8.0.12, …

mysql mysql-workbench mysql-8.0
MySQL Workbench EER Diagramm - how to change storage engine?

I use MySQL Workbench 5.2.38. and I have made an EER Diagram. But on export I got surprised with InnoDB as …

mysql-workbench
Cannot alter schema name in MYSQL 5.5 w/ MYSQL Workbench

Why I cannot alter my schema name from the MYSQL Workbench? Am i missing something? :( As you can the name …

mysql database schema mysql-workbench
Using mysqldump to format one insert per line?

This has been asked a few times but I cannot find a resolution to my problem. Basically when using mysqldump, …

mysql mysqldump mysql-workbench mysqladministrator
Declare variable syntax invalid in MySQL Workbench?

I am trying to create and set a variable: DECLARE myId INT; SET myId = 5; However, I am getting invalid syntax …

mysql syntax-error mysql-workbench declare
Create a new MySQL database using Workbench

I'm just trying to create a new MySQL database with a few simple tables. I created a new EER Model …

mysql database mysql-workbench eer-model
SQL - error code 1005 with error number 121

I'm running the following MySQL script (trimmed down), generated automatically by MySQL Workbench and I get the following error: Error …

mysql sql mysql-workbench mysql-error-1005
SQL 0 if negative value

So I want to turn negative value's into a 0. I found 2 solutions that do exactly the same: SUM(IF(ordered_…

mysql sql mysql-workbench
Import large .sql file into MySQL

I have been given a VERY large mysql backup file. It is ~630 MB... I guess someone thought it was a …

mysql mysql-workbench database-restore