Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberIt will be great if you can send me complete description ( step by step ) of what you are doing and what is expected. Screenshots will be great.
HTH
Ritesh
MemberI dont think so.
Is your remote MySQL server situated on Win2K.
Ritesh
MemberWhich version of MySQL and on what OS?
Ritesh
MemberAre you using Insert/Update window. This is a known bug and will be fixed in SQLyog 3.6. The data is correctly stored in MySQL. SQLyog interprets '&' incorrectly.
ResultWindow will show you the correct data.
HTH
Ritesh
MemberIt will be
Quote:lines terminated by 'rn'Can you attach a screenshot of the dialog box wherein you are giving the Escape characters.
Also, will it be possible for you attach the .CSV file so that we can look into it and tell you the exact Escaping characters….
Ritesh
MemberQuote:load data local infile 'c:/mysqlimport.csv' into table `import`.`import1` fields terminated by ',' lines terminated by 'n' ( `index`, `name`, `email`, `phone`, `job` );Thanks. We will work on it and fix the error ( if there are any ) in SQLyog 3.6.
Quote:but I do not seem to be able to handle the /r /n that DOS usesUse rn and /r/n
BTW, which book about MySQL/PHP did you buy?
HTH
Ritesh
MemberSpecify an *order by * clause for the column and press F8
HTH
Ritesh
MemberShadow is correct.
If you specify *database name* in the Connect To MySQL Host… dialog box, SQLyog will not issue SHOW DATABASES query, as it assumes that the databases provided exists in the server and it is a valid database. Moreover, it will only add those databases in the ObjectBrowser.
To specify multiple databases, separate them with ;
HTH
Ritesh
MemberRelationships in Synchronization Tool is planned for one of the future releases of SQLyog.
Ritesh
MemberCan you give us more details?
Which option you are trying to use?
Ritesh
MemberYou can do that!!! Just select the multiple queries and press Ctrl+F5. Multiple result tabs with result of the individual queries will be added in the Tab Window.
Great to see you back Cal !!
Ritesh
MemberWell, you can't.
MySQL does not support different date-formats.
Ritesh
MemberYes.
This feature is planned for SQLyog Max.
Ritesh
MemberWe have never tested ODBC import with an OMNIS file ( actually we dont have much knowledge about it ). Can you post us to any source where we can get more information about OMNIS?
Ritesh
MemberQuote:Is there a reason that the table export doesn't include the description/comments field?Thanks for the feature request.
Quote:Also, is there a way to add descriptions/comments to an individual column? I'm trying to make my tables more self-documentingMySQL does not support column level commenting as of now !
-
AuthorPosts