Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberQuote:CREATE TABLE name2 SELECT n.*, if(na.preferred_mail=1,”Work”,”Home”) AS mailing_preference, if(na.preferred_bill=1,”Work”,”Home”) AS billing_preference, na.address_1 AS work_address, na.address_2 AS work_address2, na.city AS work_city, na.state_province AS work_state, na.zip AS work_zip, na.country AS work_country, na.phone AS wk_phone, na.fax AS wk_fax, na.email AS work_email, na.last_updated AS last_updatedW FROM name n LEFT JOIN name_address na ON n.id=na.id AND na.purpose='WORK'Are you user that the table does not exist? If you are able to execute the query from the SQL window then the table will be created successfully. Next time when you execute the query from the Notification Wizard, it will throw up an error.
Notification Wizard can execute multiple queries. You can place a drop table statement at the beginning.
Memberpeterlaursen wrote on Aug 14 2005, 03:49 PM:Simply delete the charset's definition from the SQL-file using Notepad or another editor.it is not a SQLyog issue – it is a MySQL issue!
[post=”6851″]<{POST_SNAPBACK}>[/post]SQLyog uses MySQL's SHOW CREATE table statement in the generated dump file. The other option would be to read thru each and every columns definition and create the CREATE TABLE statement.
We prefer to use MySQL's SHOW CREATE table option because it is easier to keep up with the changes that MySQL does from version to version.
MemberI guess its high time to make all the dialog boxes resizable.
We will add an option in v4.2 where you can specify the constraint name.
MemberThanks for the feedback.
Will be fixed in v4.2.
MemberThanks.
Will be fixed in v4.2.
MemberWe basically sort the connection names in the combo box. Thus a name starting with ! is coming at the top.
I guess this is a bug and we will fix it in v4.2.
MemberImproved support for PERSONAL FOLDERS is already in the TO-DO list. Though I cannot confirm which version of SQLyog will have the option.
We indeed plan to make personal folders like favorites/bookmarks in IE/Firefox. You will be able to arrange your queries under sections/folders. It will allow you to add/edit your favorite scripts. 😀
MemberQuote:sometimes there is an error in the script. In the result pane i only get the message something is wrong but. (This is the default MySQL error message) it would be very handy to print the line in the script which was executed.This is already in the TO-DO list of SQLyog. I cannot guarantee the version in which this feature will appear. This one would require some changes in our interface.
Quote:Is it also possible to show a progress indicator during exuteing the script. I now only see the script is executng, but there is no indicator of what the progress is.This sounds interesting. Have added it up in the TO-DO list.
MemberThis should be easy to implement. I have added it in the To-DO list of v4.2.
MemberThanks.
I will put it in the TO-DO list of v4.2.
MemberCan you confirm that BETA 10 fixes the above problem?
MemberWe have released v4.1 BETA 10 that fixes the above issue. For more info, please visit http://www.webyog.com/forums/index.php?act…&st=0#entry6827
MemberWhat was the issue?
MemberThis is very strange.
ODBC 9 driver returns temporary system tables when we query it to give table info. In the case of ODBC 8 driver – it does not 😮
By default, we try to select all the tables that are returned by the driver and get their column info. When we ask for column information for the extra tables – ODBC driver throws up an error saying that there no column for the mentioned table and thus the warning in SQLyog.
I believe its an issue with ODBC driver for Oracle rather then SQLyog. Anyway, SQLyog v4.1 BETA 10 will have a workaround for this situation.
MemberWhat is your Oracle server version?
-
AuthorPosts
