[peterlaursen]

Well I don't think that would involve SQLyog at all. Just need to have MySQL running.

But of course you could use SQLyog as a client to work with the data.

[peterlaursen]

Where will I get my new monitor?

[peterlaursen]

I have a scroll-bar and I used your table definition and filled data into it so that there were more rows than could be displayed.

The asterix symbolizes non-saved rows, I think! I think this is part of a the windows API, but Ritesh must explain.

It is similar in Access and OpenOffice Base when you open a table. Don't you have it there either?

[peterlaursen]

Code:

there is no real use of stopping at an empty grid-row

You will have to stop it somehow if it shall not run forever ….

Basically INSERTION of rows is implemented differently in CREATE TABLE and ALTER TABLE. In ALTER TABLE you must click INSERT, in CREATE TABLE you just move cursor to next empty row.

I think it is not the time to change that now!

[peterlaursen]

🙂

basically Excel is to blame I think! But it will take a few weeks before I'll buy Micorsoft, so we'd better find a solution in between.

Now can't you set the type for each column (avoid auto) when importing CSV?

[peterlaursen]

I tried to follow your instructions, but failed in doing so!

5. Press TAB to switch to the next column (s2). The row you're editing disappears at all. Now it is actually not visible because it is somewhere below the data grid. NOPE it does not disappear!

6. try to move (with the mous) the scroller on the right side of the grid or clisk of their arrows.

You wil get a large number of “Suplicate entry” errors, at least 5 or 10 if you're quick enough to releas the mouse, or up to several hundreds of them! Not either, but as first step was not reproduced that could be why!

Here it looks a little bit different. See attached. What happend to that 'brick' with an asterix (*)

Did I miss something?

[peterlaursen]

Another workaround is to activate the 'language settings' toolbar from Windows 'process bar' (or whatever it is called). Now when you open Excel, higlight the Excel window, and switch the locales for just that Excel window to English. Works great with Turkish, Czech and Thai, so why not even German? 😀

Then no special SQL is needed.

looks like

[peterlaursen]

Code:

We also have an issue with the float numbers, especially with FLOAT (10,3) as they have three digits after point. MySQL delivers “3” (three) like “3.000” and Excel interprets it as 3000 (three thousand) because of German region settings. This makes things even more difficult. We even had a bad error in our financial reporting because of this!

@vygi: did this involve SQLyog?

to workaround the european regionals use string function replace(), ie.

Code:

select replace(variable,'.',',') as variable_with_comma from table; // replace '.' with ','

with the query.

[peterlaursen]

You should shut down your computer when leaving your job in my opinion!

What an irresponsible waste of energy 🙁

[peterlaursen]

@Ritesh .. I don't think you understand!

Try:

Create two columns, highligt 2nd column and click the 'insert' button. TWO (and not one) empty rows are created in grid between 1st and 2nd row. This is a GUI bug in my opinion.

I accept that it stops generating columns for the 'create statement' when parsing and meeting an empty row in the grid!

[peterlaursen]

Yes .. you are correct!

If you open 'Scheduled Tasks', right-click one and choose 'properties' it could look somewhat like

“C:ProgrammerSQLyog Enterprisesja.exe” “C:ProgrammerSQLyog Enterpriseblabla.xml” -l”C:ProgrammerSQLyog Enterprisesja.log” -s”C:ProgrammerSQLyog Enterprisesjasession.xml”

This is simply the command-line that the Windows Scheduler executes. There is no change in that with 5.1.x

However .. in this special situation (with the reported 5.11 crashing bug) I would start making a copy of the SQLyog installation folder (if you do not have a back-up allready). Also I would use 5.12 beta 3 and not 5.11.

[peterlaursen]

@Ritesh

did you read this discussion: http://www.webyog.com/forums/index.php?showtopic=2119

the 'export' tool has an option to deselect 'drop trigger' statement – the 'backup' powertool has not. Why?

[peterlaursen]

@rick

When using a database server like MySQL you should not bother! Depending on the Storage Engine used there may be one or more files for each database (MyISAM) or just one file (InnoD:cool:. The storage is controlled by the server code, and you should not attempt to access any database object from the file system at all.

The SPSs are stored 'somewhere inside the database file(s)', there is no other way to access them than using a MySQL client.

[peterlaursen]

If you installed to the same folder I don't think either it willl be necessary to do anything.

If you installed to another folder you can open each job in Task Scheduler and edit properties (change the path)

[peterlaursen]

Confirmed and reproduced with 5.12 beta 3 too.

[Author]

Posts