[peterlaursen]

yes – you just can logon mysql twice (from “File .. connect” in the menu) and tile or cascade and thereafter rearrangt the panses/windows (from “window” in the menu). You also can start sqlyog twice and logon with each instance of the program.

[peterlaursen]

With 4.0.2 User permissions works as it should here …

(but in my case previous versions did too)

[peterlaursen]

>> Ritesh

I it could be done it would be nice if the column header “LENGTH” of the CREATE TABLE and ALTER TABLE pane changed to “VALUES” when an ENUM or a SET variable is chosen as datatype. It also is not quite logical that in column LENGTH ” ' ” quotes MUST be given and in DEFAULT colum ” ' ” quotes MAY NOT …

Just a parsing detail …

I know people don't use those datatypes very much (but they should!) 😛

[peterlaursen]

I see now that in my answer 11:42 I mixed up a picture showing an ALTER statement and some SQL containing a CREATE statement. Hope it doesn't confuse too much 😮

Further more I can tell now that SET variable types are treated just like ENUM's from the sqlyog GUI ….

[peterlaursen]

it could be a firewall issue … with sqlyog you connect through TCP so most firewalls would “protect” your system.

[peterlaursen]

this one works too (omitting the ” `” -character)

alter table test.testtable , change myenumtest myenumtest enum ('Y','N') DEFAULT 'N' NOT NULL

– but you won't have to worry about that stuff if you use the sqlyog GUI

[peterlaursen]

Sorry – that went wrong , se image

[peterlaursen]

And note the diffent quotation marks, see image

alter table `test`.`testtable` ,change `myenumtest` `mynewenumtest` enum ('Y','N') DEFAULT 'N' NOT NULL

[peterlaursen]

this sql should work (it does here)

create table `test`.`TableName` (`ColumnName` ENUM('Y', 'N') NULL);

or

alter table `test`.`TableName1` ,change `ColumnName` `ColumnName` enum ('Y','N') NULL ;

(or NOT NULL with a default value)

With the sqlyoug GUI it looks like the image below . Note where to use quotes and not!

the sql corresponding to the image is

create table `test`.`enumtest` ( `qwer` enum ('Y','N') DEFAULT 'N' NOT NULL )

[peterlaursen]

>> ritesh:

well — it could be done even if the sql editor pane was not visible to the user.

But I understand that that would mean quite a big change in code structure.

>>bfalling:

then don't close the sql pane but pull the divider between the sql pane and the result pane upwards instead.

[peterlaursen]

I don't believe it's an issue with sqlyog …

The error-message looks like it's is generated by MySQL itself.

You could try running the query from “MySQL Query Generator” (download from http://www.mysql.com) and you will probably have the samme error message.

BTW – do you use INNODB tables ?

[peterlaursen]

OK 🙂

probably they will fix it will som upcoming release …

[peterlaursen]

No that wasn't it!!

here it makes no difference which of the two binaries I use.

But actually I don't think I've run the script to update user GRANT tables when I installed 4.1.8 and 4.1.9. So maybe it's a problem with the script distributed with those version ?

[peterlaursen]

I'm running 4.1.9 nt-max.

Matbe it's a workaround to change to the “max” server binary ??

[peterlaursen]

Still no problems here!

I'm running 4.1.9. And when logged on as ROOT or any user with GRANT privilege all sorts of user permissions are saved.

Do you all remember to press “apply” ?

[Author]

Posts