[sqlite] import a text to sqlite

2012-03-14 Thread YAN HONG YE
On Tue, 13 Mar 2012 02:28:38 +, YAN HONG YE yanhong...@mpsa.com wrote: here my code,where is wrong? char mma[250]; strcpy(mma,sqlite3 foods.db \ .separator ',' \ \.import dzhhkmysql.txt dzh\); system(mma); dot-commands for the sqlite3 command line tool have to be on separate lines. Do the

Re: [sqlite] import a text to sqlite

2012-03-14 Thread Larry Brasfield
On March 14, YAN HONG YE wrote: On Tue, 13 Mar 2012 02:28:38 +, YAN HONG YE yanhong.ye at mpsa.com wrote: here my code,where is wrong? char mma[250]; strcpy(mma,sqlite3 foods.db \ .separator ',' \ \.import dzhhkmysql.txt dzh\); system(mma); dot-commands for the sqlite3 command line tool

Re: [sqlite] import a text to sqlite

2012-03-14 Thread Kevin Benson
On Wed, Mar 14, 2012 at 10:04 PM, YAN HONG YE yanhong...@mpsa.com wrote: On Tue, 13 Mar 2012 02:28:38 +, YAN HONG YE yanhong...@mpsa.com wrote: here my code,where is wrong? char mma[250]; strcpy(mma,sqlite3 foods.db \ .separator ',' \ \.import dzhhkmysql.txt dzh\); system(mma);

Re: [sqlite] import a text to sqlite

2012-03-13 Thread Kees Nuyt
On Tue, 13 Mar 2012 02:28:38 +, YAN HONG YE yanhong...@mpsa.com wrote: here my code,where is wrong? char mma[250]; strcpy(mma,sqlite3 foods.db \ .separator ',' \ \.import dzhhkmysql.txt dzh\); system(mma); dot-commands for the sqlite3 command line tool have to be on separate lines. Do the

[sqlite] import a text to sqlite

2012-03-12 Thread YAN HONG YE
here my code,where is wrong? char mma[250]; strcpy(mma,sqlite3 foods.db \ .separator ',' \ \.import dzhhkmysql.txt dzh\); system(mma); ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] import a text to sqlite

2012-03-12 Thread Simon Slavin
On 13 Mar 2012, at 2:28am, YAN HONG YE yanhong...@mpsa.com wrote: here my code,where is wrong? char mma[250]; strcpy(mma,sqlite3 foods.db \ .separator ',' \ \.import dzhhkmysql.txt dzh\); system(mma); ___ Instead of using system(), write that text to a file. Then see what