Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberQuote:This must be because SQLyog internally adds singlequotes (and not doublequotes) around the strings processed ??Can you provide the corresponding SQL statement that works?
You dont need to escape “ as the following query works:
Code:load data local infile 'C:/Documents and Settings/Ritesh/Desktop/racetest.csv' into table `test`.`racetable` fields escaped by '\' terminated by ',' enclosed by '”' lines terminated by 'rn' ( `racecode`, `racedsc`, `racetot` )You only need to escape and ' 😀
MemberHow many rows are there in your database?
If you have lot of columns with BLOB data then it will take some time to generate checksums that is required for comparison.
MemberMore food for thought:
http://dev.mysql.com/doc/refman/5.0/en/nam…ensitivity.html
If you read the docs, case sensitivity applies only for database and table names and not for column names.
Quote:The columns t and T were synced as were U and u. The should not!Its correct as columns are not case-sensitive.
MemberQuote:Maybe those issues would solve themselves more or less with SQLyog 4.3 that would compile with a Unicode codebase?? As long as SQLyog uses ANSI internally there is no chance to fix it I guess! At least not worth spending time with in the 4.2 tree! But should have attentionThis is not a UNICODE issue but rather a bug with SQLyog. We never considered the issues relating to case-sensitivity between Linux and Windows boxes.
I will try to setup a MySQL server on my Linux box and work on all the cases. Should not take us more then 1 day to fix all the crash issues.
Quote:Just found that the two fields memberID and MemberID is considered the same in the structure synchronization.I have added this in the TO-DO list but I cannot guarantee the version which will have the fix.
MemberNope.
This requires complete understanding of the issue. We are planning to overhaul the CSV Export/Import system to make it more intuitive. It seems that there are quite a number of issues that we never thought of.
MemberI think you got it wrong. You will need to the escape character values with whereever required.
Attached screenshot will help in understanding the solution.
The settings will then generate the following query:
Quote:load data local infile 'U:/racetabl.asc' into table `fsbo`.`racetable` fields escaped by '\' terminated by ',' optionally enclosed by ''' lines terminated by 'rn' ( `racecode`, `racedsc`, `racetot` )MemberI understand that this is little confusing. I have added this in the TO-DO list. We plan to work on the CSV Export/Import feature to make it more intuitive.
MemberI think I got the problem 😛
Your query says:
Quote:load data local infile 'U:/racetabl.asc' into table `fsbo`.`racetable` fields escaped by '\' terminated by ',' optionally enclosed by ''' lines terminated by 'rn' ( `racecode`, `racedsc`, `racetot` )It should be:
Quote:load data local infile 'U:/racetabl.asc' into table `fsbo`.`racetable` fields escaped by '\' terminated by ',' optionally enclosed by ''' lines terminated by 'rn' ( `racecode`, `racedsc`, `racetot` )You need to escape ' with '
MemberThe TO-DO list is not publicly available.
MemberYou can mail me the csv file at [email protected].
MemberQuote:Does the location of the file affect importing?Yes.
SQLyog uses MySQL's internal LOAD LOCAL INFILE command to import data from a CSV/DELIMITED file.
If you check the HISTORY tab, you will see the corresponding SQL statement. Can you paste the SQL statement out here? Make sure that the path provided in the SQL is correct.
BTW, are you using HTTP Tunneling?
MemberSturcture sync does not support reordering columns. This feature is already in the TO-DO list of SQLyog.
You can use Tables -> Reorder Columns to reorder the columns using SQLyog GUI.
MemberThought provoking.
MemberI was researching on this strict mode issues yesterday night. It affects various options of SQLyog in varying degree of importance.
Data tab seems to be the most important one. Before taking a shortcut method, we need to decide how to handle NULL and EMPTY STRINGs. We also need to know how different column types behaves in STRICT MODE specially with and without default values.
-
AuthorPosts
