[ashwin]

Quote:

If both a column default and a column comment was specified in CREATE/ALTER TABLE a SPACE-character was missing in the generated statement causing invalid syntax error. This bug was introduced in 9.5.

We have released SQLyog v9.63 with this fix.

Please refer: http://www.webyog.com/blog/2012/03/22/sqlyog-mysql-gui-9-63-released/

[ashwin]

We have released SQLyog v9.63 with this fix.

Please refer: http://www.webyog.com/blog/2012/03/22/sqlyog-mysql-gui-9-63-released/

[ashwin]

Hi,

Could you please provide us the dummy excel file where it is reproducible?

Actually, It is the driver that interprets datatypes from the source. There is a setting in the driver- Rows to scan. Change from Start-> Run-> ODBC data source administrator-> User DSN-> Select the Excel driver-> Options-> Rows to scan. This option specifies the number of rows to scan to determine the data type of each column. The data type is determined given the maximum number of kinds of data found. You need the increase the number of rows initially scanned(Refer screen-shot)The maximum value to be specified is 16. If you have have numbers in first 16 rows then it won't interpret as varchar and therefore a .0 to the end of it. There should be some text in atleast first four rows for the driver to interpret as varchar. Same thing would result using same driver and settings with any application.

Regards,

Ashwin

[ashwin]

We will fix this in the next public release(This week). Thank you for reporting.

[ashwin]

We will look into this and update here.

[ashwin]

Addition to Larry Woods SQL query, you need to consider these-

INSERT IGNORE INTO table1

SELECT * FROM table2;

which allows those rows in table1 to supersede those in table2 that have a matching primary key, while still inserting rows with new primary keys.

Refer MySQL docs: http://dev.mysql.com/doc/refman/5.5/en/insert-select.html

Alternatively,

REPLACE INTO table1

SELECT * FROM table2;

will update those rows already in table1 with the corresponding row from table2, while inserting rows with new primary keys.

Refer: http://dev.mysql.com/doc/refman/5.5/en/replace.html

[ashwin]

Hi,

You can achieve this by following these steps:

— Create job files for Scheduled backup and Database synchronization.

Select “Save Job File” in both the wizards to run the task manually. With this option, at the following page of the Wizard you should indicate the name for the Job File which will be saved in the XML format. Refer attached image.

— Write a .bat file to execute more SJA jobs at the same time. Refer FAQ: http://www.webyog.com/faq/content/27/35/en/can-i-execute-more-sja-jobs-at-the-same-time.html

— Now schedule the job file. Refer FAQ: http://www.webyog.com/faq/content/27/33/en/how-do-i-schedule-a-job.html for more details.

This way you can “batch process” multiple schedule items sequentially.

Regards,

Ashwin

[ashwin]

Issue confirmed. We will fix it with priority.

[ashwin]

@Smine,

This is reproducible for us if the double datatype column is not the first column in the Excel sheet. This seems to be a driver issue and nothing to do with SQLyog. Office 2007 SP3 also it is reproducible 🙁

[ashwin]

Hi,

I would like to clarify what exactly you mean by 'crash'. Do you mean that

1. SQLyog becomes unresponsive and white over, and Task manager says SQLyog is Not Responding? (this is actually called hanging, rather than crashing)

Or

2. You get a dialog saying SQLyog has crashed? If so, could you attach the crash dump(s) here?

Regards,

Ashwin

[ashwin]

Hi,

I have added your feature request in our issue-tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1768

This will be implemented in SQLyog v10(Probably this month).

Thank you for using SQLyog and for your suggestion.

Regards,

Ashwin

[ashwin]

Quote:

* It is now optional if Query Builder will create statements with ‘fully qualified tablenames’ or not.

Read 9.6 release blog. Please install latest GA- 9.61 and try.

[ashwin]

Hi,

We have released 9.6 GA with this fix. Please refer: http://www.webyog.com/blog/2012/02/21/sqlyog-mysql-gui-9-6-released/

Regards,

Ashwin

[ashwin]

Hi,

Quote:

We will add keyboard shortcuts to insert/delete/move-up/move-down as ALT+INSERT/ALT+DELETE/ALT+UP arrow/ALT+DOWN arrow respectively in 9.6GA.

We have released 9.6 GA with this enhancement. Please refer: http://www.webyog.com/blog/2012/02/21/sqlyog-mysql-gui-9-6-released/

– Implemented Alt+Ins, Alt+Del, Alt+Up and Alt+Down for inserting, deleting, moving up/down the rows in CREATE|ALTER TABLE interface when the focus is on respective grids. The tooltip for the toolbar buttons will now show this shortcuts.

Regards,

Ashwin

[ashwin]

Hi Mitch,

Quote:

I think it make more sense for the output to remain in Form mode until explicitly switched back to Grid mode.

This will be implemented in SQLyog v10(probably around mid-March).

Thank you for your suggestion.

Regards,

Ashwin

[Author]

Posts