[chill]

Thanks Ritesh for the info

My query results were not being exported because I was not clicking on the 'export' button – surprise, surprise :roll:. I followed Cal's advice and that export feature worked as expected.

However, no matter what I do, I still cannot get the tab delimetered data columns to line up as expected when query results exported to a textfile. I have tried t and even tt in both fixed length and variable length formats but still end up with some un-alligned columns. I have noticed that this happens when the text in a particular column exceeds a certain length. I'll try the CTRL + C as u suggested to copy the data in tab delimetered format to see if that would help.

Quote:

You can not update a table with no Primary Key defined in SQLyog. You have to write your own SQL stmt. to do that.

Regarding the above quote, can the SQL stmt be written and executed in SQLyog or must that be done at the console?

Thanks

Peter 😀

[chill]

Thanks Cal for the prompt and extremely informative response

I am still at the school so I am not able to verify the SQLyog version number on my PC at home. However, I downloaded and installed the latest available version about two weeks ago.

I set up MySQL on my PC and I have full privileges. It is true that I can't insert any data or any other form of editing on database tables containg no primary keys in SQLyog (even when these containe foreign keys). There is this message which state that such tables are read only and to support this, clicking on the grids have no effect. Incidentally, I was able to insert new values in tables containg primary keys.

That problem with the “off” first line obtained from a pasted query result occurred even when the columns were delimeters as fixed width.

I will definitely keep using SQLyog to become to familiar with the features. Your comments have been of immense help. Armed with the knowledge that the features do work, motivates me to find a way to make them work on my machine 😛 – well I will try my best :P.

Hey there is nothing wrong with a bit of humour 😀 . Wish that most of the other techno-geeks out there could have some too 😀 😀 😀 😀

Thanks

Peter

[Author]

Posts