On Fri, Jul 22, 2011 at 04:44:53PM +0300, George wrote: > I'm looking for software that will accept as input a csv file and a database > schema and will populate the database with the data in the csv. I'm not > talking > about something simple that will fill a single table, but rather something > that > can work foreign key constraints and can respect one-to-many, many-to-one and > many-to-many relations.
You haven't told us which database software you're using (CSV is a kind of database, but I'll ignore the trivial cp), so I'll assume mysql. $ mysqlimport --fields-terminated-by=\, --fields-enclosed-by=\" MyDatabase MyBackup.csv > > > -- > To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org > with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org > Archive: > http://lists.debian.org/CAO=sjovt_u_tjuhuye7fwfpb+6s+m1dxoqdpw1vzgh-75fb...@mail.gmail.com > -- -- Paul Saunders
signature.asc
Description: Digital signature
