Re: CSV import

2007-05-31 Thread Mogens Melander
Import your CSV-data into a temporary table, using mysqlimport, and throw a bit of SQL at it might do the trick, but then again, not knowing the layout of your table, nor the data you want to import, i'm only guessing. On Mon, May 28, 2007 16:57, Sharique uddin Ahmed Farooqui wrote: Both

RE: CSV import

2007-05-28 Thread Sandesh Nair
Try SQLYOG software Thanks Regards, Sandesh Nair -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sharique uddin Ahmed Farooqui Sent: Monday, May 28, 2007 11:56 AM To: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: CSV import I want to import

Re: CSV import

2007-05-28 Thread Geoffroy Cogniaux
Hi, It can be done easily with PhpMyAdmin, but it is not in .net 2007/5/28, Sharique uddin Ahmed Farooqui [EMAIL PROTECTED]: I want to import data from a CSV file in a table. MySql admin doesn't support import from CSV files. Format of data is different from structure of table. Is there any

Re: CSV import

2007-05-28 Thread Sharique uddin Ahmed Farooqui
Both PhpMyAdmin and SQLYOG doesn't support customised mapping. My cvs data structure is diff from mysql table. I just want to import values for one field only. Previously I was using Mysql Front but it crashes. Also this s/w very old and discontinued. Why mysql doesn't implement it in

Re: CSV import

2007-05-28 Thread Baron Schwartz
Sharique uddin Ahmed Farooqui wrote: Both PhpMyAdmin and SQLYOG doesn't support customised mapping. My cvs data structure is diff from mysql table. I just want to import values for one field only. Previously I was using Mysql Front but it crashes. Also this s/w very old and discontinued. Why

Re: CSV import

2007-05-28 Thread Martijn Tonies
Both PhpMyAdmin and SQLYOG doesn't support customised mapping. My cvs data structure is diff from mysql table. I just want to import values for one field only. Database Workbench does, see www.upscene.com Previously I was using Mysql Front but it crashes. Also this s/w very old and