Dear friends, I import data to my table,from CSV file.CSV file has emails in each row. While importing, A window pops up stating number of rows imported, however when I see the table, nothing has been imported.
Version of mysql, gui and structure of table has been pasted. Any guidance with regard to this scenerio and issue, please. Thank you. ------------------ Mysql version: 4.0.17-nt Using SQLyog as gui +------------+-----------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+-----------------+------+-----+---------+----------------+ | NO | int(5) unsigned | | PRI | NULL | auto_increment | | WEBADDRESS | varchar(50) | YES | | NULL | | | ADDRESS | varchar(200) | YES | | NULL | | | FIRSTNAME | varchar(240) | YES | | NULL | | | LASTNAME | varchar(240) | YES | | NULL | | | EMAIL | varchar(23) | | | | | | REMARKS | varchar(240) | YES | | NULL | | | PHONE | varchar(240) | YES | | NULL | | | FAX | varchar(240) | YES | | NULL | | | EMAIL2 | varchar(240) | YES | | NULL | | | STATE | varchar(240) | YES | | NULL | | | CITY | varchar(240) | YES | | NULL | | | COUNTRY | varchar(240) | YES | | NULL | | | ZIP | varchar(240) | YES | | NULL | | | POSTALCODE | varchar(240) | YES | | NULL | | | TITLE | varchar(240) | YES | | NULL | | | SALUTATION | varchar(240) | YES | | NULL | | | CUSTOM3 | varchar(240) | YES | | NULL | | | CUSTOM4 | varchar(240) | YES | | NULL | | | CUSTOM5 | varchar(240) | YES | | NULL | | | CUSTOM6 | varchar(240) | YES | | NULL | | | PRIMARYKEY | int(6) | | PRI | 0 | | | COMPANY | varchar(29) | YES | | NULL | | +------------+-----------------+------+-----+---------+----------------+ 23 rows in set (0.00 sec)
