Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberNo.
To edit data, select the table in the ObjectBrowser and press Ctrl+Enter to start the Insert/Update dialog 😀
HTH
Ritesh
MemberHello
Yog is a Sanskrit work which means work with dedication . Thats what we stand for work with dedication to create GREAT PRODUCTS
Ritesh
MemberHello
Just install SQLyog 3.11. It will automatically upgrade everything to be SQLyog 3.11 compatible
HTH
Ritesh
MemberHello
The exported CSV looks fine. It seems that you are not providing the correct escaping characters.
To solve the problem, click Change… button in Export As CSV… dialog and use the settings which I have provided in the screenshot
Quote:use rn in as the Line Escaping characterHTH
Ritesh
MemberHello
How many columns were present in the table before you started the Alter Table option….
Ritesh
MemberHello
Thanks for the great review. We will put a link to your website when we update our site 😀
Ritesh
MemberWe are still working on it…..
Ritesh
MemberHello
SQLyog does not check for these errors. It will only give error if MySQL returns an error. By default MySQL truncates data whereever necessary.
It is the job of the end-user ( in this case the user of SQLyog to see that they dont give data more then what is required ) 😀
We do plan some simple verification in future releases of SQLyog but as of now you have to make sure that you dont give any unwanted data
HTH
Ritesh
MemberCan you give us the complete steps which you are following when SQLyog crashes?
Are you using the Insert Table dialog box or Alter Table dialog box….
Waiting for your response :huh:
Ritesh
MemberHello
Will it be possible to attach the following three things –
- .SQL backup of the test database you created
- .CSV file that was created using SQLyog
- The settings you used to export the data in CSV
We are in the process of releasing SQLyog 3.5 that will be completely MySQL 4.1 compatible. If there any bugs with our Export functionality, we can fix it in SQLyog 3.5.
Ritesh
MemberHello
Its working on my side :huh:
BTW, are you pressing OK when the escape character dialog box is coming up?
Ritesh
MemberHello
We looked into your .SQL file. One of the table data has lot of escaped data which our parser is not able to detect properly.
We are working on it and most probably will be fixed in SQLyog 3.2 which we are going to release next month.
HTH
Ritesh
MemberHello
This is a known bug :huh: We will be coming out with SQLyog v3.2 next month which will have this bug fixed and will be completely MySQL 4.1 compliant
HTH
Ritesh
MemberHello
It seems that you are not selecting Continuous rows of data…. This option only works if you have selected a series of rows.
e.g. To select from row# 10 to row# 30, click on the 10th row and then hold down Shift key and click on row#30. Dont select row#30 first and then row#10. This feature is by design
HTH
Ritesh
MemberQuote:insert into data (fldBody) VALUES ('c:test');Change the query to
insert into data (fldBody) VALUES ('c:\test');
You have to escape the character '' with '\'
HTH
-
AuthorPosts