Re: [MonetDB-users] [Monetdb-developers] about import *.csv

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 You must reply to the mailinglist, and not to me directly. In order to help you with your segmentation fault you also must provide what version you are using. Op 12-07-10 06:57, kun ren schreef:

Thank you, when I am trying,something is wrong, when i use command," mclient -l sql -d demo" and then use command "create table t1(name char(100),number int);" to create a table; and then I create a csv file, the content of the file is: renkun,1 shaolong,2 laoluo,3 and then i use command as you said,"copy 3 records into t1 from 1.csv delimiters ',','\n';" but the server said:"Segmentation fault ",what wrong with me?thanks Best regards;

2010/7/12 Stefan de Konink mailto:stefan@konink.de>

On Mon, 12 Jul 2010, kun ren wrote:

Dear all, I want to import *.csv into MonetDB,what interface do i will use？

Just mclient, create your table. And use copy into so for example

copy i<<numofrows>> records into <<justcreatedtable>> from 'filename' delimiters ',', '\n', null as '';

Stefan

-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.15 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAkw6oSYACgkQYH1+F2Rqwn1OzwCglSIGOl+tKxMk+bbDPPaLUX+i plwAn0aeeJKs3TLiNk4cHPURovJqh8T7 =+Tr/ -----END PGP SIGNATURE-----