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
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
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
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
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
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