MySQL Forums - Workbench - Newbie

Workbench not opening (no replies)

Richaer Lewis — Wed, 22 May 2013 20:00:38 +0000

Installed latest MySQL on win 2003 server with full install. When I try to open the editor I get a window that opens and closes saying the editor is opening but it never does. I have seen this issue posted but have not seen a solution. Can u help?

MySQL Workbench 6.0 – A Sneak Preview (no replies)

Edwin Desouza — Wed, 22 May 2013 16:04:23 +0000

MySQL Workbench 6.0 – A Sneak Preview
http://insidemysql.com/mysql-workbench-6-0-a-sneak-preview/

Trying to start wrong service name (no replies)

Dimitri Topaloglou — Wed, 22 May 2013 14:21:22 +0000

I just installed MySQL server along with Workbench. The first time I tried name the service "MySQL CM" but wouldn't accept the space between and reduced to "MySQLCM" and it worked. Upon opening Workbench, I wanted to start the server by pressing "Star Server" button, but it was looking for the original service name "MySQL CM" and not the new one. So I keep having to find the new service name in Windows Server to manually start it from there. Is there a way I can change the Service Name so I don't have to do all this?

Workbench Catalog Tree problem (2 replies)

Johann Lima — Sun, 19 May 2013 22:41:13 +0000

Hi, there is a problem with my workbench EER Diagram. The Catalog Tree have three databases, but there must be only one. How to move tables from one database to another or how to delete the extra databases?

Thanks in advance,

Missing Overview/output/history/snippets from 5.2.47 (2 replies)

M N — Mon, 13 May 2013 07:49:49 +0000

Hi,

I'm trying to follow this page for the workbench manual
http://dev.mysql.com/doc/workbench/en/wb-sql-editor-results-tabsheets.html

but I don't seem to have any of those tabs shown in the example picture...

Is there something I'm missing?

I'm using Workbench
5.2.47 CE
Revision 10398

On Windows 7
MySql 5.6 installed

Thanks

storage engine (1 reply)

Dimitris Papageorgiou — Fri, 10 May 2013 19:53:52 +0000

from where in the workbench I can see the storage engine of a table

What does it mean to have a connection without an instance? (3 replies)

M N — Fri, 10 May 2013 20:32:16 +0000

Hi,

I installed mysql 5.6 and played around with the command line and created a database and a simple table.

Then I went through the 5.6 manual and it had me first create a server instance.

What are the ramifications of having a db without an instance?

Is there a word bank somehwere or key terms definition list somewhere?

Server Running but instance is stopped and cant' start it? (2 replies)

M N — Thu, 09 May 2013 17:48:38 +0000

Hi,

I"m going through the 5.6 manual step by step and find that after making an new instance the "Server Status" "Status" says it is running.

But in the "Startup/Shutdown" tab it says:

"The database server instance is stopped"

even when I click "Start Server"

the startup message log says:
Checking service status of instance MySQL...
Status check of servers 'MySQL' returned stopped

thoughts?

Unable to Open mysql Excel Connection (2 replies)

Mylie Murray — Thu, 09 May 2013 03:10:43 +0000

I have been trying to open mysql excel connection but though my password is rightly type I can't able to connect. Any thoughts why?

Anything obvious i am doing wrong? (no replies)

Michael Macneil — Fri, 03 May 2013 15:07:03 +0000

Hi folks, just ran the full install of the mysql msi and everything seems to install right and initial config completes. However, when i start workbench and click on Import/Export or Administer secrity i get an exception. If i run the command line import i get the same msg in the trace:

C:\Program Files\MySQL\MySQL Workbench CE 5.2.47\utilities>mysqldbimport --serve
r=root:elfab@localhost --import=both --bulk-insert --format=sql "E:\Temp\ElfabTe
chMySQL\ElfabTech2942013 20130429 1155.sql"
# Source on localhost: ... connected.
# Importing definitions and data from E:\Temp\ElfabTechMySQL\ElfabTech2942013 20
130429 1155.sql.
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench CE 5.2.47\utilities\scripts\mysql
dbimport.py", line 188, in
dbimport.import_file(server_values, file_name, options)
File "C:\Program Files\MySQL\MySQL Workbench CE 5.2.47\python\mysql_libs.zip\m
ysql\utilities\command\dbimport.py", line 1017, in import_file
File "C:\Program Files\MySQL\MySQL Workbench CE 5.2.47\python\mysql_libs.zip\m
ysql\utilities\command\dbimport.py", line 761, in _exec_statements
AttributeError: 'ProgrammingError' object has no attribute 'errmsg'
Unable to start mysqldbimport, please verify that your installation is correct

However, it does seem that the database and schema have imported as i can query with the workbench, just cannot use any of the admin tools.

Any suggestions??

Call Function by create new DB (1 reply)

Franz Engel — Wed, 01 May 2013 17:09:42 +0000

Hi,

Is there a methode to insert a script in the EER Diagramm that will be called by create a new database.
Currently I do the following:
- Design my EER diagram
- Export create script with "File->Export->Foward Engineering SQL Create Script..."
- Run the create script to create a new database
- Insert some standard values
I use the database to store measurement values. Each database is excatly one experiment. So I do the 4 Steps a lot of times. The most time I need for the 4th step (Insert standard values).
Is it possible to automated this task by the EER Diagramm, for example with a function that will be called by a "create db trigger".

Thanks and regards,
franz

ERR with initial values (1 reply)

Franz Engel — Thu, 02 May 2013 08:46:00 +0000

Hi,

Is it possible to insert data in the ERR? I have a specific table that should have specific values when the database will be created by the creating script. Is there a way to insert "standard" data in the ERR-Diagram?

Thanks and regards,
Franz

Undiagrammed Catalog Tables (1 reply)

lawrence karthauser — Thu, 02 May 2013 08:47:19 +0000

I have got the catalog and diagrams to work, and can see how they relate.

How can I find tables that are in the catalog but not on any diagram? It is important to me that all tables have been documented.

I suppose I will have to write a script - but surely this is a common requirement.

Thanks

Lawrence

Is there a limit to the # of ELSEIFs? (3 replies)

Michael Howes — Mon, 29 Apr 2013 07:34:12 +0000

I'm working on migrating some data from a really messy (aka bad) schema to a new one. There is also some terribly messy data I'm trying to clean up.

I have a simple stored procedure that has a VERY large IF THEN ELSE structure that compares a short string and decides which value to match it up to in the lookup table.

I don't understand what my syntax error is in this procedure

it won't let me alter the proc (apply the altered proc) because it says there is a syntax error. Line 56 which is the 2nd line here, has the NULL in the insert marked red and says "parser stack overflow"

ELSEIF pformat = '7"+7" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 8);
ELSEIF pformat = '7"aaa' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);

simply is this too many ELSEIFs for Workbench?

thanks
mike

-- --------------------------------------------------------------------------------
-- Routine DDL
-- Note: comments before and after the routine body will not be stored by the server
-- --------------------------------------------------------------------------------
DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_PressingsFormatsFromAlbums`(
IN pressingID INT(10),
IN pFormat VARCHAR(255))
BEGIN

IF pFormat = '' THEN SELECT NULL;
ELSEIF pformat = '7' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = '10"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 13);
ELSEIF pformat = '10" EP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 13);
ELSEIF pformat = '10" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 14);
ELSEIF pformat = '12"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
ELSEIF pformat = '12" ' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
ELSEIF pformat = '12" EP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
ELSEIF pformat = '12"+2x7"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 39);
ELSEIF pformat = '2x12"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 18);
ELSEIF pformat = '2x7"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 6);
ELSEIF pformat = '2xCD' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 24);
ELSEIF pformat = '2xCDR' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 28);
ELSEIF pformat = '2xLP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 30);
ELSEIF pformat = '2xtape' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '2 x Tape', 39);
ELSEIF pformat = '3x7"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '3 x 7"', 39);
ELSEIF pformat = '3xCD' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 25);
ELSEIF pformat = '3xLP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '3 x LP', 39);
ELSEIF pformat = '3xtape' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '3 x Tape', 39);
ELSEIF pformat = '4x7"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '4 x 7"', 39);
ELSEIF pformat = '4xCD' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '4 x CD', 39);
ELSEIF pformat = '4xCD box set' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '4 x CD', 39);
ELSEIF pformat = '5"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 1);
ELSEIF pformat = '5" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 2);
ELSEIF pformat = '5x7"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '4 x 7"', 39);
ELSEIF pformat = '5x7" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '5 x 7" flexi', 39);
ELSEIF pformat = '5xCD' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '5 x CD', 39);
ELSEIF pformat = '5xCD box set' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '5 x CD', 39);
ELSEIF pformat = '6" EP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 3);
ELSEIF pformat = '6" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 4);
ELSEIF pformat = '6xLP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '6 x LP', 39);
ELSEIF pformat = '7"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = '7" ' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = '7" + 7" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 8);
ELSEIF pformat = '7" EP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = '7" EP ' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = '7" EP + 7" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 8);
ELSEIF pformat = '7" EP+7" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 8);
ELSEIF pformat = '7" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 7);
ELSEIF pformat = '7" flexi ' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 7);
ELSEIF pformat = '7" flexi EP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 7);
ELSEIF pformat = '7""' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = '7"+7" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 8);
ELSEIF pformat = '7"aaa' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = '7aaa' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = '7aaaaaa' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = '7x7"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '7 x 7"', 39);
ELSEIF pformat = '8"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 10);
ELSEIF pformat = '8" EP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 10);
ELSEIF pformat = '8" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 11);
ELSEIF pformat = 'CD' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = 'CD ' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = 'CD EP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = 'CD single' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = 'CD-R' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 27);
ELSEIF pformat = 'CD+DVD' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 26);
ELSEIF pformat = 'CD5' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = 'CDEP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = 'CDR' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 27);
ELSEIF pformat = 'demo' THEN SELECT pressingID, pformat;
ELSEIF pformat = 'demo tape' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 37);
ELSEIF pformat = 'EP' SELECT pressingID, pformat;
ELSEIF pformat = 'LP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
ELSEIF pformat = 'LP ' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
ELSEIF pformat = 'LP + 7" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 32);
ELSEIF pformat = 'LP+12"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, 'LP + 12"', 39);
ELSEIF pformat = 'LP+7"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 31);
ELSEIF pformat = 'LP+7" EP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 31);
ELSEIF pformat = 'LP+7" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 32);
ELSEIF pformat = 'LP+7" flexi ' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 32);
ELSEIF pformat = 'split 10"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 13);
ELSEIF pformat = 'split 12"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
ELSEIF pformat = 'split 12" EP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
ELSEIF pformat = 'split 2x7"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 6);
ELSEIF pformat = 'split 7"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = 'split 7" EP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = 'split 7" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 7);
ELSEIF pformat = 'split 8"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 10);
ELSEIF pformat = 'split 8" flexi' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 11);
ELSEIF pformat = 'split CD' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = 'split LP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
ELSEIF pformat = 'split tape' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 37);
ELSEIF pformat = 'tape' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 37);
ELSEIF pformat = 'tape ' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 37);
ELSEIF pformat = 'unreleased 12"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
ELSEIF pformat = 'unreleased 7"' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = 'unreleased 7" EP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
ELSEIF pformat = 'unreleased album' SELECT pressingID, pformat;
ELSEIF pformat = 'unreleased EP' SELECT pressingID, pformat;
ELSEIF pformat = 'unreleased LP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
ELSEIF pformat = 'unreleased split LP' THEN INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
ELSEIF pformat = '7"/10"' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 13);
ELSEIF pformat = '7"/10"/12"' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 13);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
ELSEIF pformat = '7"/10"/12"/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 13);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '7"/10"/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 13);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '7"/12" ' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
ELSEIF pformat = '7"/12"' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
ELSEIF pformat = '7"/12" EP' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
ELSEIF pformat = '7"/12"/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '7"/12"/CDEP' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '7"/2x7"' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 6));
ELSEIF pformat = '7"/2x7"/10"/12"' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 6);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 13);
ELSEIF pformat = '7"/2x7"/12"' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 6);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
ELSEIF pformat = '7"/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '7"/CDEP' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = 'CD/LP' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
ELSEIF pformat = 'CD/tape' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 37);
ELSEIF pformat = 'LP/4x7"/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '4 x 7"', 39);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = 'LP/CD ' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
ELSEIF pformat = 'LP/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = 'LP/CD/tape' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 37);
ELSEIF pformat = 'LP/tape' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 37));
ELSEIF pformat = '10"/12"' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 13);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
ELSEIF pformat = '10"/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 13);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '12"/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '12"/CD EP' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '2x7"/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 6);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '2xLP/2xCD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 30);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 24);
ELSEIF pformat = '2xLP/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 30);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '5x7"/LP' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, '5 x 7"', 39);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
ELSEIF pformat = '2x12"/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 18);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '7" EP/10" EP' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 3);
ELSEIF pformat = '7" EP/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '7" EP/CDEP' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '7" EP/tape' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 5);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 37);
ELSEIF pformat = 'LP+7"/2xCD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 31);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 24);
ELSEIF pformat = 'LP+7"/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 31);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = '12" EP/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 17);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSEIF pformat = 'split LP/CD' THEN
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 29);
INSERT INTO kfth.pressing_formats (PressingId, Other, FormatsId) VALUES (pressingID, NULL, 23);
ELSE SELECT pressingId, pFormat;
END IF;

END

Name result tab of query (7 replies)

Michael Kahler — Mon, 29 Apr 2013 13:50:07 +0000

Hello,
Is it possible to rename the result tab after a query has run? I have 3 results returned from a script that contains 3 queries, and I get back one tab with a name of the database and a 1 (earthquakes 1), and the other 2 are named Result 2, Result 3. Here is the script if that will help.

use earthquake;
select * from earthquakes order by DateTime desc limit 0,1000000;
select avg(Magnitude) from earthquakes;
select count(Magnitude) from earthquakes;

I would like to have the result 2 be named Average and result 3 be named Count.

Thank you in advance!

Workbench does not retrive all rows (not related to the 1000 rows limit) (4 replies)

Michel Jodoin — Fri, 26 Apr 2013 20:58:47 +0000

Hi everyone,

first time poster because usually I find my answers on Google but this time I can't find it.

Here is the situation:
I'm using a desktop computer to host MySQL and I'm using Workbench 5.2. This is located at my house. The computer is only used for this reason.

I'm using Access as the FE from my home and from my office.

Because the internet is slow at my office, I thought I would use Workbench on my laptop that would make a connection to my desktop computer.

This solution is working much faster BUT the issue is that not all rows are retrieved.

We are not talking about a huge number of rows (the biggest table has maybe 3-4k rows) and I ran some test to see where the issue was coming from:
-If I use Select from a table with 95 rows and from the direct connection to the server, I can retrieve all 95 rows
-If I use Select from the same table of 95 rows but from the connection on my Workbench to the Workbench on my desktop computer at my house, I only retrieve 42 rows

This situation is not unique to this table but it's the same and in a similar proportion (about half is retrieved) to all the other tables.

In your answer, please bear in mind 2 things:
-I am not a MySQL wizard, I am a small window cleaning company owner
-English is my 2nd language

Thank you for your time

can not create any odbc connection (3 replies)

Peter Späth — Wed, 24 Apr 2013 17:02:35 +0000

I just installed MySQL Workbench (Release 5.2.47) for development and reverse engineering purpose. Operating systems is Windows 7 64 bit.
So first I want to create an ODBC connection for my database - a system DSN already exists. But - when I open the dialog "manage DB connection" I find only 3 items as connection method: Standard, local socket and standard TCP, but no ODBC. I already downloaded and installed several ODBC Connectors (V5.2, 32 bit and 64 bit) but the drop down menu wont expand.
Am I completely wrong the way want to connect to ODBC or did I forgot to download / install something additionally?

File Encoding Problem when opening script that contains Blob (no replies)

Jan Frederik — Fri, 19 Apr 2013 21:17:06 +0000

When I load a value from file (an image) into a field with datatype Blob, then export it via Admin Tab -> Data Export and open it in an SQL tab i get a File Encoding Problem Message. When I accept the suggested "Latin1"-Encoding the Image will be corrupted afterwards.

The collation for the schema is utf8 but when I input utf8 in the above mentioned dialog it says sth. like "can't encode utf8 to utf8".

SELECT without Result Set Tab? (1 reply)

Menachem Bazian — Wed, 17 Apr 2013 07:37:07 +0000

Hi everyone,

I could use an assist with something.

I am building a table with two fields, ID and MatchID. The first is an autoincrementing ID and the second an integer column that will hold a random integer between 1 and 86,000. I will generate about 2,000 of these rows.

My insert code runs like this:

SET @randint= CAST(RAND()*86000 as signed);
SELECT @varexists:=COUNT(*) from ids where matchid = @randint;
IF @varexists = 0 then
INSERT INTO ids (matchid) values (@randint);
set @count = @count + 1;
END IF;

I am running this in MySQL workbench. Every time the SELECT runs, MySQL Workbech generates a result set tab for it. I would like to avoid that as it is unnecessary. Is there a way for me to do that?

Thanks

INNODB setting in WB (1 reply)

Don Giddens — Mon, 15 Apr 2013 19:15:39 +0000

I am running MySQL 5.5.29 on Windows 2008 R2 Server. The server has a mix of MyISAM & InnoDB tables with InnoDB being the default database engine. Looking at the servers configuration settings in MySQL Workbench, I can see that the “default-storage-engine=INNODB” under the General tab. However, if I look under the INNODB tab I see an option “InnoDB” that is set to “OFF”. There is a checkbox next to this setting, but it is not selected. Possible values for this option are “ON”, “OFF” & “FORCE”.

It would appear from the startup log that InnoDB is started, but I don’t understand the purpose of the “InnoDB” option. Does this need to be enabled for InnoDB to function properly? The only thing I read about this was in regard to the “FORCE” option, which basically prevent the server from starting without InnoDB support. If I don’t want to use the FORCE option, what is the relevance of the ON/OFF setting in relationship to the “default-storage-engine” setting under the General tab?

Thanks

Cannot make a new connection (1 reply)

Corne Lombaard — Mon, 15 Apr 2013 07:59:48 +0000

I have just installed the Workbench and I tried to make a new connection but to no avail. I have read some comments and I have changed the bind address in my.cnf and restarted the server but nothing the same error:

Failed to Connect to MySQL at 127.0.0.1:3306 with user root
Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Any help is appreciated

Retrieving connection string from Workbench? (3 replies)

James Nicholson — Tue, 23 Apr 2013 07:43:03 +0000

Is there some way in Workbench to see the default connection string for a particular database?

MySQL 5.6 unable to edit table (1 reply)

Nirmala Rajarethnam — Mon, 15 Apr 2013 06:55:22 +0000

Hello,

I am new to this blog and using MySQL. I just installed MySQL workbench and browsing around.

I was able to open the existing sample table in edit mode with all options. How ever I created table and inserted values through SQL queries. How ever when i open the table by right clicking "Edit table data" looks like its read only.

Can someone help, what I am doing wrong here, do I need to enable something?

Thanks in advance.

Duration vs fetch issue (2 replies)

Matthew Moles — Tue, 09 Apr 2013 15:14:28 +0000

I know this kind of question has been asked several times, but I seem to have in issue in my understating of them. My understanding of the terms is:
- Duration: time taken for query to fully execute on server (not affected by things like network latency/speed)
- Fetch: time taken for data to fully transfer to client (Affected by things like network latency/speed)

This does not appear to be the case in 5.2.47
For a query of select * from tbl where id =x (where id is indexed )
Over the internet Duration is between 0.015 and 0.032, and fetch is 0
Over a local network both duration and fetch are 0.

Is my understanding wrong or is this a bug?

Worbench V5.2.47
OS: Win 7 SP1 Enterprise 64 bit
Mysql server: 5.5.22
Area: Query editor – output window

Select statement help (no replies)

jordan elphick — Sun, 07 Apr 2013 23:29:45 +0000

Hi Guys and Gals,

I am trying to retrieve data from my tables that are in '3rd Normal Form'

(i.e. First Normal Form: My Table columns are atomic and cannot be divided into smaller meaningful parts, no columns contain duplicate data,Second Normal Form: the table is dependant upon the primary key, Third Normal Form: Non-key columns cannot describe other non-key columns)

When I retrieve data from the table I am shown the results. However I am only shown the primary key values (integers) of the table which I am shown. These integers are the unique keys that relate to other tables, of which contain the data.

Instead of retrieving these integer values, is there a way to have the retrieved values display the text strings that are found on the table to which the key identifies?

Is there a 'blanket' method for doing this so that this is done for all values ..

Currently I am using "SELECT * FROM vehicles". Some of the columns in the vehicles table include: idVehicle, idMake, idVehicleType, Registration. idMake,idVehicleType are the keys to the VehicleMake and VehicleType Tables respectively.

As you can probably tell I am quite new to SQL databases, so please feel free to make ridicule!

Jordan

Need_info_about_wait_lock_time_out (1 reply)

shiva v — Mon, 08 Apr 2013 06:27:06 +0000

Hellow Memeber,

Can you any one let me know what is the maximum size of wait_lock_time_out in my.cnf

file,,Default value is 50sec. If i make this once as 120sec..wether it happens any thing please share me some info about this

Thanks

Shiva(9700900269)

Workbench (1 reply)

Adrian Schlesinger — Wed, 03 Apr 2013 21:09:12 +0000

I really don't know how to put this. Just how can you release versions for this "software" that are loaded with huge bugs. Bugs is not enough a word for them. It seems people that work on it simply don't care about anything, or that software technology has just been invented yesterday. Do you ever test your work? Do you ever use your product? I seriously doubt it. UNBELIEVABLE.

MySQL Workbench,how to auto write upcase? (1 reply)

kingdelee lee — Tue, 02 Apr 2013 08:04:28 +0000

my MySQL Workbench write sth it shows like "select * from tb_user where id = 1;"
i want to when i write it,it will auto toupcase shows like "SELECT * FROM tb_user WHERE id = 1;"
where i can config the workbench?
thank you!

Workbench makes too much disk usage on mysql connect (5 replies)

Filipe C — Wed, 10 Apr 2013 13:42:09 +0000

passing variable in Where IN (no replies)

gujju desi — Thu, 28 Mar 2013 20:44:23 +0000

How can I achieve this

set @namelist = "'nick','ED','grace',''dan'";
select * from actor where first_name IN (@namelist)

please help me out, thank you in advance