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
> 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 <geoffroy.cogniaux@stripped> wrote:
>> It can be done easily with PhpMyAdmin, but it is not in .net
>> 2007/5/28, Sharique uddin Ahmed Farooqui <sharique@stripped>:
>> > 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.
+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.