Forum for SQL Browser, Editor and Refactor. http://forums.mysql.com/list.php?161 Wed, 19 Jun 2013 06:03:14 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?161,588764,588764#msg-588764 http://forums.mysql.com/read.php?161,588764,588764#msg-588764
in earlier Versions of the mySQL Workbench it was possible to close the
current (query-browser-)tab using the accelerator Ctrl+W (or Strg+W).

I know that it has been replaced by Ctrl+F4.
But that requires two hands and is not a standard (a large number of
Software running under Windows also supports the accelerator).

Since that shortcut is not in use, I would suggest to support both
accelerators (Ctrl+F4 and Ctrl+W).

Is that a big deal?

Best regards, Uwe]]> Uwe Beierlein Workbench - SQL Browser, Editor, Refactor Tue, 18 Jun 2013 11:37:52 +0000 http://forums.mysql.com/read.php?161,585613,585613#msg-585613 http://forums.mysql.com/read.php?161,585613,585613#msg-585613
OS :OSX
Workbench version : 5,2,47

I am quiet new using Workbench.
My problem is when i am inserting data into MySql (UTF-8) table from Workbench like "Français", it seems to work fine, and when I am querying from Workbench I get "Français" as result , SUPER ... in fact not!!

When getting the same data from a web page, the "ç" character is spread on 2 characters unreadable.

My second try was to insert from the web page directly in the table then it is Workbench that gives me some special characters.

I have read some tips on the web, and changing the font (several times) didn't help me.

Any ideas to help me?
Thanks a lot in advance.
Luc]]> Luc Cotton Workbench - SQL Browser, Editor, Refactor Mon, 13 May 2013 08:02:56 +0000 http://forums.mysql.com/read.php?161,583404,583404#msg-583404 http://forums.mysql.com/read.php?161,583404,583404#msg-583404
CREATE TABLE `hamneggs`.`goesto` (
`usr_id` INT NOT NULL ,
`spr_id` INT NOT NULL ,
PRIMARY KEY (`usr_id`, `spr_id`) ,
INDEX `usr_id_idx` (`usr_id` ASC) ,
INDEX `spr_id_idx` (`spr_id` ASC) ,
CONSTRAINT `usr_id`
FOREIGN KEY (`usr_id` )
REFERENCES `hamneggs`.`users` (`usr_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `spr_id`
FOREIGN KEY (`spr_id` )
REFERENCES `hamneggs`.`sprints` (`spr_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION);

it's the representation of a N:N relationship between users and meetings, what can be the problem?

thank you!!]]> estefania rabadan Workbench - SQL Browser, Editor, Refactor Mon, 08 Apr 2013 15:00:14 +0000 http://forums.mysql.com/read.php?161,581065,581065#msg-581065 http://forums.mysql.com/read.php?161,581065,581065#msg-581065
I can confirm that MySQL Workbench works correctly on Fedora+KDE so I don't if this is an exclusive Ubuntu+KDE issue or what.

I'm running Kubuntu 12.10 along with latest MySQL Workbench 5.2.47.]]> Franck Fallateuf Workbench - SQL Browser, Editor, Refactor Mon, 11 Mar 2013 23:15:50 +0000 http://forums.mysql.com/read.php?161,579962,579962#msg-579962 http://forums.mysql.com/read.php?161,579962,579962#msg-579962
I bring up workbench, open an existing connection, start a new query tab .. things work until I type a * ... select * .. causes, in my case, workbench to swamp my machine for the next 3-5 minutes until workbench dies and releases my system.

System.. 64bit Linux Mint quad core i7

Linux ase 3.5.0-18-generic #29-Ubuntu SMP Fri Oct 19 10:26:51 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux

DISTRIB_ID=LinuxMint
DISTRIB_RELEASE=14
DISTRIB_CODENAME=nadia
DISTRIB_DESCRIPTION="Linux Mint 14 Nadia"


Anyone else seeing something similar or have any ideas what might cause said behavior?

Next, any chance that Workbench is dropping a crash file somewhere ?]]> Mike Moran Workbench - SQL Browser, Editor, Refactor Tue, 26 Feb 2013 07:38:36 +0000 http://forums.mysql.com/read.php?161,579215,579215#msg-579215 http://forums.mysql.com/read.php?161,579215,579215#msg-579215
Memory usage is not particularly high for the workbench. But the disk trashing has slowed down the performance of my machine and has become very annoying.

Anyone else notice the same?]]> HIU HEI WONG Workbench - SQL Browser, Editor, Refactor Fri, 15 Feb 2013 04:00:31 +0000 http://forums.mysql.com/read.php?161,578525,578525#msg-578525 http://forums.mysql.com/read.php?161,578525,578525#msg-578525
Thanks!]]> Shawn Foust Workbench - SQL Browser, Editor, Refactor Mon, 11 Feb 2013 07:51:15 +0000 http://forums.mysql.com/read.php?161,578248,578248#msg-578248 http://forums.mysql.com/read.php?161,578248,578248#msg-578248
I have a problem where I have created tables within my schema but when I go to edit the data in the tables, I select the schema and only one of my tables I have created appear and the others aren't in the list.

Does anyone no why this is and how I can solve the issue?

Thanks.]]> Nima Mistry Workbench - SQL Browser, Editor, Refactor Fri, 01 Feb 2013 08:13:11 +0000 http://forums.mysql.com/read.php?161,577806,577806#msg-577806 http://forums.mysql.com/read.php?161,577806,577806#msg-577806
I have installed the product, linked to my remote database and created an ERR with relationships. I can see how to run a basic SELECT query. But I just cannot see how to create a query that involves, for example INNER JOINS on many-to-many intersection tables.

would appreciate any advice.
Dave]]> dave dfnomad Workbench - SQL Browser, Editor, Refactor Fri, 15 Feb 2013 14:25:29 +0000 http://forums.mysql.com/read.php?161,577491,577491#msg-577491 http://forums.mysql.com/read.php?161,577491,577491#msg-577491 I am having a very peculiar issue with MySQL Workbench on our work network. I am able to connect/query remote databases from command line but in MySQL Workbench I can only connect and queries timeout. I believe the issue has to do with the network/firewall but am looking for some help in diagnosing and troubleshooting it

Details:
Within this "work" network MySQL Workbench can connect to all remote databases. When I attempt to run a query that would return in milliseconds the query just spins/hangs until the connection is lost (error 1203). What is even more interesting about this is that in the same "work" network via command line I can connect to these same remote databases and query from them without issue. I can also connect to these same remote databases and successfully run queries from another third party MySQL client called "Emma"

From other networks like my "home" network I can connect to these remote databases and query from them without issue from both command line and MySQL Workbench

Based onthe information above it seems like this issue is specific to this network/firewall. I worked with our IT team and they turned off all firewall settings and even put me out in the DMZ but I still was having same issues. That seems like it should rule out firewall so maybe network issues?

Other things to note:
- To access the remote databases I am VPN'ing into the network first. I am connecting to VPN on all networks so this doesn't seem to be the issue
- These are normal tcp/ip connections to the remote databases
- Other people in the office that use MySQL Workbench on Mac and Windows are not experiencing this issue

Why would MySQL command line work and MySQL workbench not? Why would MySQL Workbench work fine on this network on other OSes? Are there any settings in MySQL workbench that I could alter to fix this? Any ideas of how to troubleshoot this?


Setup
OS: Ubuntu 12.10 64-bit
Workbench Version: 5.2.45
VPN: Cisco VPN service

Thanks in advance,

Simon]]> Simon Engelbert Workbench - SQL Browser, Editor, Refactor Fri, 18 Jan 2013 15:58:48 +0000 http://forums.mysql.com/read.php?161,576127,576127#msg-576127 http://forums.mysql.com/read.php?161,576127,576127#msg-576127
I have a database I access using sql workbench. when I run a query

select * from user_credential

I get four rows returned with all columns. When I query

select fieldname from user_credential

I get a ERROR 1054 Unknown column. I created the table with

CREATE TABLE user_credential (
 K INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
 userK INT NOT NULL,
 service VARCHAR(20) NOT NULL,
 fieldname VARCHAR(20) NOT NULL,
 fieldvalue TEXT
);

when I look at the table using the workbench everthing looks fine. What have i missed ??]]> Mark Bateman Workbench - SQL Browser, Editor, Refactor Thu, 03 Jan 2013 08:49:40 +0000 http://forums.mysql.com/read.php?161,575987,575987#msg-575987 http://forums.mysql.com/read.php?161,575987,575987#msg-575987
I am working on a mysql module for my new assignment which requires me to port data from x server to y server.
Both X and Y are 2 different MySQL Server for which I have sufficient privileges for inserting data.
I have 2 tables in X - Source Server and same 2 tables created in Y - Designation Server with the same table structure.
Now, I should be able to port the data from X to Y for these 2 tables.

I was able to achieve this using Microsoft's SSIS Package - but I need to know whether we have any other tools available with MySQL to do it - with minimal tasks and complexity.

Any help on this would be much appreciated.

Thanks,
Vinodh]]> Vinodh Kumar Workbench - SQL Browser, Editor, Refactor Fri, 14 Dec 2012 07:47:12 +0000 http://forums.mysql.com/read.php?161,575952,575952#msg-575952 http://forums.mysql.com/read.php?161,575952,575952#msg-575952 mysql 5.1.45
mysql workbench 5.2.44

From the manual 13.1.7 Alter Table syntax
When you specify an ENGINE clause, ALTER TABLE rebuilds the table.
This is true even if the table already has the specified storage engine.

I have seen the following "null" operation mentioned as a way to 'compact' or 'defragment' an INNODB table.
ALTER TABLE tbl_name ENGINE=INNODB

That makes sense. However, what is the effect of this rebuild on a series of INNODB tables that use auto-increment indexes and foreign keys to those indexes?

I could set foreign key checks off, then do the ALTER operations, then set FK checking back on.

set @@foreign_key_checks=0;
ALTER TABLE person ENGINE=INNODB;
ALTER TABLE badges ENGINE=INNODB;
ALTER TABLE documents ENGINE=INNODB;
ALTER TABLE training ENGINE=INNODB;
ALTER TABLE counties ENGINE=INNODB;
set @@foreign_key_checks=1;

How are the foreign keys affected here? Will all of the 'cross-references' be maintained here?

Would I need to do the ALTER operations in a particular order?

Below are examples of the create statements. The table 'person' is the main table.

CREATE TABLE `person` (
`person_id` int(11) NOT NULL AUTO_INCREMENT,
`memberid` int(11) NOT NULL DEFAULT '0' COMMENT 'assigned member id number - not auto-increment',
`firstname` varchar(35) NOT NULL,
`middlename` varchar(35) DEFAULT NULL,
`surname` varchar(35) NOT NULL,
`address` varchar(100) DEFAULT NULL,
`city` varchar(35) DEFAULT NULL,
`state` varchar(2) DEFAULT 'TX',
`zip` varchar(10) DEFAULT NULL,
`homephone` varchar(35) DEFAULT NULL,
`workphone` varchar(35) DEFAULT NULL,
`cellphone` varchar(35) DEFAULT NULL,
`carrierid` int(4) NOT NULL DEFAULT '1' COMMENT 'ref to carrier for text messaging',
`email` varchar(64) NOT NULL,
`callsign` varchar(10) NOT NULL,
`licenseclass` varchar(10) DEFAULT NULL,
`districtid` int(11) NOT NULL COMMENT 'ref to district table',
`countyid` int(11) NOT NULL COMMENT 'ref to county table',
`titleid` int(11) NOT NULL COMMENT 'ref to title table',
`position` varchar(35) DEFAULT NULL COMMENT 'role or assignment associated with this county and this title',
`updated` datetime NOT NULL COMMENT 'date and time last updated',
`multiplecounties` tinyint(1) NOT NULL DEFAULT '0',
`comments` varchar(255) DEFAULT NULL,
`powercomm` tinyint(1) DEFAULT '1' COMMENT 'only commercial power available',
`powerbatt` tinyint(1) DEFAULT '0' COMMENT 'battery power available\n',
`powergen` tinyint(1) DEFAULT '0' COMMENT 'generator power available',
`powersolar` tinyint(1) DEFAULT '0' COMMENT 'solar power available',
PRIMARY KEY (`person_id`),
KEY `fk_districtid` (`districtid`),
KEY `fk_countyid` (`countyid`),
KEY `fk_titleid` (`titleid`),
KEY `fk_carrierid` (`carrierid`),
CONSTRAINT `fk_carrierid` FOREIGN KEY (`carrierid`) REFERENCES `carriers` (`carrier_id`) ON DELETE NO ACTION ON UPDATE CASCADE,
CONSTRAINT `fk_countyid` FOREIGN KEY (`countyid`) REFERENCES `counties` (`county_id`) ON DELETE NO ACTION ON UPDATE CASCADE,
CONSTRAINT `fk_districtid` FOREIGN KEY (`districtid`) REFERENCES `districts` (`district_id`) ON DELETE NO ACTION ON UPDATE CASCADE,
CONSTRAINT `fk_titleid` FOREIGN KEY (`titleid`) REFERENCES `titles` (`title_id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1223 DEFAULT CHARSET=latin1 COMMENT='individual person detail profile';

CREATE TABLE `training` (
`personid` int(11) NOT NULL,
`courseid` int(11) NOT NULL,
`verified` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'completion of this course has been verified with documentation',
PRIMARY KEY (`personid`,`courseid`),
KEY `fk_pid` (`personid`),
KEY `fk_cidx` (`courseid`),
CONSTRAINT `fk_cidx` FOREIGN KEY (`courseid`) REFERENCES `courses` (`course_id`) ON DELETE NO ACTION ON UPDATE CASCADE,
CONSTRAINT `fk_pid` FOREIGN KEY (`personid`) REFERENCES `person` (`person_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='intersection table to link persons with courses';

CREATE TABLE `badges` (
`personid` int(11) NOT NULL,
`pixfile` varchar(50) NOT NULL DEFAULT '' COMMENT 'filename of picture image: basename + extension',
`badgeissued` datetime DEFAULT '0000-00-00 00:00:00' COMMENT 'date a badge was issued',
PRIMARY KEY (`personid`),
KEY `fk_pixpid` (`personid`),
CONSTRAINT `fk_pixpid` FOREIGN KEY (`personid`) REFERENCES `person` (`person_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='entries for member pictures and badge-issue dates';

CREATE TABLE `counties` (
`county_id` int(11) NOT NULL AUTO_INCREMENT,
`districtid` int(11) NOT NULL,
`county` varchar(20) DEFAULT NULL,
`showorder` int(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`county_id`),
KEY `idx_districtid` (`districtid`),
CONSTRAINT `counties_ibfk_1` FOREIGN KEY (`districtid`) REFERENCES `districts` (`district_id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=latin1 COMMENT='lookup table of counties in the section, with district';]]> Judy Whiteside Workbench - SQL Browser, Editor, Refactor Wed, 12 Dec 2012 21:42:53 +0000 http://forums.mysql.com/read.php?161,574870,574870#msg-574870 http://forums.mysql.com/read.php?161,574870,574870#msg-574870 Mysql is 5.1.45-community

After running an INSERT or UPDATE, I need to capture the complete message as shown in the Action Output message panel.

For example:
775 row(s) affected Records: 597 Duplicates: 304 Warnings: 0

However using Select row_count() only gives the 775 number
show warnings; gives no output at all (expected, as there are no warnings)

The manual seems to say that show Warnings will give some information messages, but apparently that is only referring to warning-information-messages, not general information of any kind.

I particularly need the Duplicates number after running ON DUPLICATE KEY UPDATE work.

How can I get this number, or this text string to parse?]]> Judy Whiteside Workbench - SQL Browser, Editor, Refactor Tue, 04 Dec 2012 13:21:07 +0000 http://forums.mysql.com/read.php?161,573198,573198#msg-573198 http://forums.mysql.com/read.php?161,573198,573198#msg-573198
So essentially, I'd love to be able to say: ON UPDATE: IGNORE, ON DELETE: IGNORE

I considered adding the missing data, adding the FK's, then deleting the missing data again, but doing so may endanger the entire row of data in the referencing table, or is that only if the it's set to CASCADING?]]> george gallen Workbench - SQL Browser, Editor, Refactor Fri, 09 Nov 2012 14:45:02 +0000 http://forums.mysql.com/read.php?161,572898,572898#msg-572898 http://forums.mysql.com/read.php?161,572898,572898#msg-572898 mysql workbench 5.2.44

In the Action Output panel of the SQL Editor, the icons (green checkmark, red error-X) are useful.

Today I noticed the icons are flickering, as if work was going on, but no query was executing or anything. Many different icons flicker on several completed lines.

This is a minor point, but it sure seems like something is doing work that I don't know about, and maybe don't need.

I am just using my local test db. There is no remote connection (though there has been earlier in the day.)

In Task Manager, the highest cpu load is 3%, and it is by mysql workbench.
There is only one instance of mysql Workbench running.

Is this benign? or is there something else I can check on?]]> Judy Whiteside Workbench - SQL Browser, Editor, Refactor Mon, 05 Nov 2012 15:25:23 +0000 http://forums.mysql.com/read.php?161,572856,572856#msg-572856 http://forums.mysql.com/read.php?161,572856,572856#msg-572856
Child | Parent
---------------------
tttt | pppp
pppp | xxxx
tttt | gggg
gggg | tttt
xxxx | ffff
xxxx | hhhh
xxxx | kkkk
xxxx | mmmm

and I trace for a given child ref to show me the associated links

SELECT 'tttt' as Child,
t1.Parent,
t2.Parent,
t3.Parent,
t4.Parent,
t5.Parent
FROM
data_table AS t1
LEFT JOIN data_table AS t2 ON t1.Parent = t2.Child
LEFT JOIN data_table AS t3 ON t2.Parent = t3.Child
LEFT JOIN data_table AS t4 ON t3.Parent = t4.Child
LEFT JOIN data_table AS t5 ON t4.Parent = t5.Child
LEFT JOIN excluded AS ex1 ON ex1.Excluded_Ref = t1.Parent
LEFT JOIN excluded AS ex2 ON ex2.Excluded_Ref = t2.Parent
LEFT JOIN excluded AS ex3 ON ex3.Excluded_Ref = t3.Parent
LEFT JOIN excluded AS ex4 ON ex4.Excluded_Ref = t4.Parent
LEFT JOIN excluded AS ex5 ON ex5.Excluded_Ref = t5.Parent
WHERE
t1.child = 'tttt' and (ex1.Excluded_Ref is null
and ex2.Excluded_Ref is null
and ex3.Excluded_Ref is null
and ex4.Excluded_Ref is null
and ex5.Excluded_Ref is null);

The problem I have is that it correctly identifies the links for me, but actually ref 'xxxx' is linked to so many others that when I try and run my trace it takes so long to complete, and probably gets stuck in a loop because 'xxxx' may eventually link back to 'tttt'. Is there a way to stop MySQL actually joining or linking any further any refs I have in my excluded table? In my excluded table, for example, I will have ref: xxxx. So in my join above the trace of 'tttt' would stop or ignore the 'xxxx' path.]]> Mark Rouse Workbench - SQL Browser, Editor, Refactor Fri, 02 Nov 2012 19:25:17 +0000 http://forums.mysql.com/read.php?161,572410,572410#msg-572410 http://forums.mysql.com/read.php?161,572410,572410#msg-572410
When entering data trough the GUI, when the row, table, database and mysql client settings in my.cnf are properly configured to UTF-8, entering special characters in the GUI table editor does not work. For example if I enter "č", it will be show up as "?" after the query has completed.

How do I set the character set of the GUI, so that I can enter special characters into tables trough it?

If this is not supported, where can I file a bug report?

Thanks.

LP,
Jure]]> Jure Sah Workbench - SQL Browser, Editor, Refactor Tue, 30 Oct 2012 10:28:15 +0000 http://forums.mysql.com/read.php?161,572398,572398#msg-572398 http://forums.mysql.com/read.php?161,572398,572398#msg-572398
Is it possible, to add new foreign key constraints to the tables of a database AND deleting all data, that doesn't fit?

One of my database (~500 MB, 360 tables) was wrong imported and there are over 80 missing foreign key constraints. Now there are so much incorrect references in the database, and now it starts to cause some problems.

Thank you,
Richard]]> Richard Vogel Workbench - SQL Browser, Editor, Refactor Mon, 29 Oct 2012 09:56:31 +0000 http://forums.mysql.com/read.php?161,572327,572327#msg-572327 http://forums.mysql.com/read.php?161,572327,572327#msg-572327 Joe Harper Workbench - SQL Browser, Editor, Refactor Mon, 29 Oct 2012 09:08:21 +0000 http://forums.mysql.com/read.php?161,570456,570456#msg-570456 http://forums.mysql.com/read.php?161,570456,570456#msg-570456 Workbench version 5.2.43 CE Revision 9869
MySQL 5.5.27
I'm relatively new to MySQL and the Workbench but I've noticed about half the time or more when I enter simple SELECT statements in Workbench the CPU usage on my local machine where MySQL is installed spikes up to around 60%. It will stay that way for several minutes, maybe longer. I can stop this by going to the Output window, right clicking and selecting CLEAR. One of the visible cues is that while the CPU load is high as in this situation, the icons (in the left most column of the Output window) appear to be flickering or repainting at a high rate. While searching for a solution to this I've noticed similar bugs such as bug #13642999, and bug #64077 but they were supposedly fixed in Workbench 5.2.41. Thanks.

--John

P.S. This is running on Windows XP SP3]]> John Steele Workbench - SQL Browser, Editor, Refactor Tue, 30 Oct 2012 08:23:36 +0000 http://forums.mysql.com/read.php?161,567977,567977#msg-567977 http://forums.mysql.com/read.php?161,567977,567977#msg-567977 http://stackoverflow.com/questions/11245475/can-not-create-table-in-mysql-workbench-5-2-40

When I change to mysql-installer-5.5.16.0.msi, everything just works fine!

Does anyone know what's the problem?]]> Gang Qian Workbench - SQL Browser, Editor, Refactor Mon, 10 Sep 2012 08:23:19 +0000 http://forums.mysql.com/read.php?161,566531,566531#msg-566531 http://forums.mysql.com/read.php?161,566531,566531#msg-566531
How can I display the columns in a table in Schema browser and/or the object info panel in table order rather than alphabetical order?

How can I multi-select columns and send to editor/clipboard/select/edit?

Object information panel defaults to only the column information and to see related table information i have to drill down to the foreign keys and then it will be visible at the table level.

I have recently upgrade to 5.2.42 running on Windows from a previous version where workbench worked this way so my hope is this is just a setting I have missed and not a progressive design feature.

Thanks for your help

Paddy]]> Patrick Mulvany Workbench - SQL Browser, Editor, Refactor Mon, 29 Oct 2012 09:10:38 +0000 http://forums.mysql.com/read.php?161,565810,565810#msg-565810 http://forums.mysql.com/read.php?161,565810,565810#msg-565810
LIKE:

-DB_TEST
- Tables fetching
- Views fetching
- Routines fetching

if I create a new table
-DB_TEST
- Tables fetching
+ new_table
- Views fetching
- Routines fetching]]> disller z Workbench - SQL Browser, Editor, Refactor Tue, 11 Sep 2012 13:42:15 +0000 http://forums.mysql.com/read.php?161,564539,564539#msg-564539 http://forums.mysql.com/read.php?161,564539,564539#msg-564539
However, I am noticing weird behavior in regards to Execute Current Statement command (Command + Enter)

1. Connect to a database
2. Open a new tab
3. Enter some SQL (e.g. show processlist)
4. Hit "Command + Enter" to run

(NOTE: You will see the "Query" toolbar menu option at the top flash)

5. Watch and you may (or may not) see that your query has been executed.

In the event that it did run, repeat these steps (new tab, enter SQL, run query hot-key) ...it is reliably un-reliable, to say the least.

I find that I am having to hit Command-Enter two to three times before my query is actually executed. It seems to be something related to running SQL on a New Tab.

Anyone else experiencing this on v5.2.41 (OS X)?

I have posted a more detailed bug report here: http://bugs.mysql.com/bug.php?id=66286]]> Mike Reid Workbench - SQL Browser, Editor, Refactor Thu, 09 Aug 2012 17:39:37 +0000 http://forums.mysql.com/read.php?161,560780,560780#msg-560780 http://forums.mysql.com/read.php?161,560780,560780#msg-560780
I didn't find any post related to context help during writing SQL queries in SQL Editor.

Is it possible to configure via plugins or other ways to have context help menu?
Most of IDE has context help menu on Ctrl+Backspace.

SQuirreL example:
For example if you try to enter 'select * from inf' and then Ctrl+Backspace you will get


MySql Workbench example:
On Windows it shows something similar to context help menu but empty. (On Mac it doesn't work at all):
]]> Mykhailo Oleksiuk Workbench - SQL Browser, Editor, Refactor Tue, 17 Jul 2012 05:57:48 +0000 http://forums.mysql.com/read.php?161,558272,558272#msg-558272 http://forums.mysql.com/read.php?161,558272,558272#msg-558272
Is there a way of changing the Syntax Highlighting colours because I find the Orange a little too light and it's too hard to read at times.

I can see I can change some colours under the Appearance tab of the Preferences but those are only for the EER diagrams

thanks for your help]]> haydn flower Workbench - SQL Browser, Editor, Refactor Sun, 24 Jun 2012 23:20:46 +0000 http://forums.mysql.com/read.php?161,557749,557749#msg-557749 http://forums.mysql.com/read.php?161,557749,557749#msg-557749
I am using the test schema for now, it's set as the default schema for the connection (it's bold in the list on the left). I have granted all the permissions on that schema to my user.

When I try and create a very simple function, the editor returns really bizarre results.

First the code :

delimiter $$
create function wtf()
returns integer
begin
return 5;
end$$


When I try and execute this I get the response

1 10:47:50 create function wtf() returns integer begin return 5; end 0 row(s) affected, 1 warning(s): 1304 FUNCTION wtf already exists

If I refresh the schema tree, the function shows up. (No it wasn't there BEFORE I executed the code).

Ok fine. New window.

call wtf();

0 10:54:26 call wtf() Error Code: 1305. PROCEDURE test.wtf does not exist


As the function name suggests...WTF is going on?

I am completely lost. Any help is appreciated.

Chris
(MySQL 5.5.25, Workbench 5.2.4)]]> Chris Cheshire Workbench - SQL Browser, Editor, Refactor Tue, 19 Jun 2012 07:36:09 +0000 http://forums.mysql.com/read.php?161,557697,557697#msg-557697 http://forums.mysql.com/read.php?161,557697,557697#msg-557697
Error Code 2008: MySQL Client ran out of memory

Are there specific server variables I can increase that will fix this? I'm using a Win 7 64-bit box with 16GBs of RAM.

The reason for doing a select * is so I can export the data as an xls formatted file.]]> Mark Rouse Workbench - SQL Browser, Editor, Refactor Mon, 25 Jun 2012 13:12:24 +0000 http://forums.mysql.com/read.php?161,557247,557247#msg-557247 http://forums.mysql.com/read.php?161,557247,557247#msg-557247
Once you design a table, I couldn't find any method to print it out to the printer. Nor could I figure a way to print out a listing of tables contained in the schema?

Am I just overlooking it?]]> george gallen Workbench - SQL Browser, Editor, Refactor Tue, 12 Jun 2012 00:26:27 +0000