[peterlaursen]

OK .. think I got it …

But it did not behave quite like this here.

Did you have all queries in one JOB as I?

I'd like to hear Ritesh's opinion.

After all it is not documented that a set of queries like these are not possible.

[peterlaursen]

I don't understand now ….

Quote:

If you go back and come press NEXT, the query is again checked for its validity and thus the error

I did not “go back”. I imported the table definitions and ran the query from SQL-pane. New table was created as it should. Then I dropped the database, created a new empty one, Started Notification Service Wizard, chose not to send mail – just run maintenaince script. When I got to the SQL window I pasted in the complete query (or rather queries) and pressed the “next”button and error message occurred.

Could someone pliiiiiiiiiise explain to me what was the point I did not get ? 😮

[peterlaursen]

@ritesh

and BTW – don't forget to update this screen.

F8 is not “execute for update” anymore

[peterlaursen]

Quote:

When someone presses F5 (or hits the single green arrow), and several queries exist, show a dialog with a note along the lines of “You have entered several queries. You can run all these queries by pressing F8 or by clicking the double arrowed button. Run currently selected query anyway?”. With yes/cancel buttons, and a “Do not show this again” tickbox option.

If someone enters or pastes in several queries, then I suspect in the majority of cases they expected all of them to be executed.

I don't think I agree. On the opposite I hate alle these dialogue boxes that M$ has trained us to think is a natural thing.

The SQL-pane easily gets filled up with hundreds of individual querries! Some will cause errors – others might do undesired things. I would not risk to execute all queries when I only need to do one

Since there is a sinnge-arow and a double-arrow available I think that is is it should be. If F8 is change to have the double-arrow function thne that is Ok with me too.

You can also “mark up” a section of code in SQL-pane with the mouse and press F5. Then queries inside that section will execute

A configurabale hotkey-manager is on the TO DO list. But other issues have been considered more important until now

[peterlaursen]

@ Ritesh

Since Sqlyog version 4.05 there has been no difference in F5 and F8.

Wouldn't it be an idea to change functionality of F8 to “execute all queries”

At the same time let Ctrl+Enter be the same as F5 as has been requested before by quite a lot of users!

[peterlaursen]

I never heard about it before. And I think it is a simple issue

Quote:

I paste this SQL code into the SQL box in SQLyog and hit F5

try hiiting the “double green arow” icon with the mouse instead! F5 executes only ONE query (limited by the ;-character).

Quote:

don't know what the difference is between InnoDB and MyISAM

very briefly the INNODB supports Foreing Keys and transactions what MyISAM does not. The MyISAM storage engine is written as optimized to MySQL code. Optimization of INNODB has also taken place with recent MySQL-versions.

MyISAM is originally written for MYSQL, INNDB started as a “foreign” project to MySQL. More to study here http://www.innodb.com/index.php

My experience with “older” MySQL versions (that is up to 4.0.x) is that MyISAM is about 50% faster than INNODB. With the INNODB-code of 4.1 and 5.0 the difference is not that big.

[peterlaursen]

This is a matter of taste, I belive.

But there is no option now to have more connections in same window.

Work is going on for a cross-platform version (Win+mac OS-X + Linux). As far as I know this one will have a “tree of connections”. But a fully functional and stable version will be no less than a year.

Development time I believe depends also on how many people buy the current version of the program. There is no revenue with the cross-platform version development.

[peterlaursen]

Actually an option to “spool” HISTORY to a file would be useful, I believe too.

[peterlaursen]

Yes.

It seems that there is a problem with the parser!

Testet on MySQL 5.0.11

And I also confirm that that it all works from SQL-pane!

[peterlaursen]

I think I got what I need now!

Did you consider the possibility that this is an ALIAS issue as well ?

[peterlaursen]

something's wrong!

you pasted in

name_adress NOT not adress!

If I rename to adress I get the error

“Unknown column 'address.field1' in 'field list'”

I think the querries that you posted here are not quite exact ?

BTW – what is the MySQL version running on your local ?

[peterlaursen]

Quote:

Problem: When editing a saved session under Notification Services Wizard, I'm unable to pass the Query window because of “Duplicate column name”.

can you edit the XML-file and execute successfully from commandline ?

I would not mind testing it you pasted in the MySQl table definitions for

Name

Address

Individual Profile

Corporate Profile

.. actually I installed mySQL 3.23 yesterday, so I can have a similar setup.

Do you use tunnelling ?

[peterlaursen]

I don't understand quite either. Though your first posting shold be clear enough.

What happens if you insert

“drop table if exists …”

before the

“create table select … “

or simply execute

“drop table if exists …”

when you had the error msg

[peterlaursen]

Quote:

though it is not listed in the Object Browser

it does not show up when up press the refresh-button ?

[peterlaursen]

Quote:

Or should I look somewhere besides Program FilesSQLyog Enterprise and Documents and Settings?

The SQLyog log files (sqlyog.err, sja.log) are in SQLyog installation directorory. program filessqlyog etc …

The MySQL log file are in log directory under your MySQl server installation directory. I would recommend “MySQL Administrator” to read those files.

Which log files are you looking for?

SQlyog is somewhat “oldfashioned” in that respect it does not use the Documents and Settings -folder, as most NT-based programs do. The way SQLyog does is more Win95-style.

[Author]

Posts