Please note: If this FAQ s empty you must choose English language from the drop-down-box below. Only English content is available as of now!
Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program

- Connection issues

- Using the GUI
- Managing your MySQL Database Systems

- Database Schema Synchronization
- MySQL DATA synchronization
- Notification Services
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)

- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Instant Response
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (115507 views)
- Error no. 2003: Can't connect... (52172 views)
- Error no. 1251: "Client does not support authentication..." (48114 views)
- Error no. 1045: "Connection denied..." (41381 views)
- SQLyog Version History (39997 views)
- What is HTTP-tunneling? (29319 views)
- Error No. 2005: Unknown MySQL server host... (28413 views)
- What Is SSH and SSH-tunneling? (25519 views)
- Why are Stored Procedures not created when I import ... (23500 views)
- Do I need PHP to use SQLyog with MySQL? ... (21534 views)
Latest FAQs 
- SQLyog Version History (2010-03-09 03:20)
- SQLyog is a client for the MySQL server - ... (2009-09-11 07:48)
- Can I use SQLyog with the various SQL-modes available ... (2009-08-20 08:02)
- Failed dependency for libstdc++.so.5 error (2009-08-13 11:22)
- Wrong results are returned for FOUND_ROWS(). (2009-08-12 06:31)
Importing external data
When I import CSV data using the SQLyog Import External Data Tool only first column of data is inserted/updated.
It is not a SQLyog issue, but an issue with the Microsoft text-ODBC-driver. It is
the same issue as described here: http://www.webyog.com/faq/28_73_en.html:
And in most of continental Europe (where the comma is used for decimal notation - ie: "4.123,7" instead of English notation "4,123.7") it is a de facto convention to use semicolon and not comma!
This is also true for the Microsoft text-ODBC-driver that comes with localized versions of Windows in countries using "," (comma) for decimal notation, that it assumes the use of ";" (semicolon) and not "," (comma) for field separator within the CSV-file. If your CSV-file(s) use(s) "," (comma) and if you have such localized Windows you must 'search and replace' the comma with a semicolon. There are lots of freeware and cheap shareware editors and other tools available that can do that - also with multiple files at a time.
Tags: -
Related entries:
- Do I need PHP to use SQLyog with MySQL?
- SQLyog gives you the most options for connecting to MySQL
- Welcome to the Webyog FAQ
- Installation and upgrading
- Buying and Licensing SQLyog
Last update: 2006-01-06 21:29
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ