I've been trying to import fields that contains the comma character ',' inside double quotes '"', with the results following:
<code> mysqlimport --fields-optionally-enclosed-by=""" --fields-terminated-by=, --lines-terminated-by="\r\n" --ignore-lines=1 --user=root --password shark "c:\documents and settings\shamm\desktop\result.csv" Enter password: ********** mysqlimport: Error: Row 48 was truncated; it contained more data than there were input columns, when using table: result Line 48: "48", "14.729606", "10.1.1.22", "10.182.167.209", "TCP", "pop3 > 1111 [SYN, ACK] Seq=0 Ack=1 Win=16384 Len=0 MSS=1460" mysql> desc result; +-------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+-------+ | No | int(10) unsigned | NO | | | | | Time | text | NO | | | | | Source | text | NO | | | | | Destination | text | NO | | | | | Protocol | text | NO | | | | | Info | text | NO | | | | +-------------+------------------+------+-----+---------+-------+ 6 rows in set (0.03 sec) C:\Documents and Settings\shamm>mysql --version mysql Ver 14.12 Distrib 5.0.26, for Win32 (ia32) </code> -- -------------------------------------------------------------------- `Twas brillig, and the slithy toves Did gyre and gimble in the wabe: All mimsy were the borogoves, And the mome raths outgrabe. --------------------------------------------------------------------
