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 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 MysqlAdmin? > -- > Sharique uddin Ahmed Farooqui > (C++/C# Developer, IT Consultant) > A revolution is about to begin. > A world is about to change. > And you and me are "the initiator". > > On 5/28/07, Geoffroy Cogniaux <[EMAIL PROTECTED]> wrote: >> >> 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 app/snippet written for this task in .net , which I can >> > modify according to my need. >> > >> > -- >> > Sharique uddin Ahmed Farooqui >> > (C++/C# Developer, IT Consultant) >> > A revolution is about to begin. >> > A world is about to change. >> > And you and me are "the initiator". >> > >> > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > > -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
