Re: [sqlite] Writing and reading a csv using sqlite3

cope though. Phil Hibbs. -- Don't you just hate self-referential sigs? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Writing and reading a csv using sqlite3

statements terminated with a ; sqlite .mode csv sqlite delete from test; sqlite .import test.csv test sqlite select * from test; test 1 test 2 sqlite Phil Hibbs. -- Don't you just hate self-referential sigs? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Writing and reading a csv using sqlite3

don't have a C compiler here at work, I'll look into installing one at home. I really should, it's been a long time since I did any C. Thanks for the replies. Is this something that should be fed back into the master source for shell.c? Should I post to the devs list? Phil Hibbs. -- Don't you just

Re: [sqlite] Stupid noob question - can't find table

are looking at the right database. Phil Hibbs. Don't you just hate self-referential sigs? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] round problem?

, then it is implementation-defined which one is taken. So I guess round half to even is a reasonable interpretation, but I'd like to see this, and all implementation-defined behaviour, documented. Phil Hibbs. -- Don't you just hate self-referential sigs? ___ sqlite-users

Re: [sqlite] round problem?

a little dirt. I'm a little surprised that it's going wrong with a number ending in 0.5 though, I'd have thought that that would be expressible perfectly in binary without loss. I don't know enough about it though. Phil Hibbs. -- Don't you just hate self-referential sigs

Re: [sqlite] Writing and reading a csv using sqlite3

. Phil Hibbs. -- Don't you just hate self-referential sigs? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] bug: round problem?

Simon Slavin: Nice try. The rounding rule is that a .5 rounds to the nearest even number. No it isn't: sqlite select round(40226+0.5); 40227.0 sqlite select round(40227+0.5); 40228.0 sqlite select round(40228+0.5); 40229.0 sqlite select round(40229+0.5); 40230.0 Phil Hibbs. -- Don't you

Re: [sqlite] Writing and reading a csv using sqlite3

to respect the MODE_Csv setting on import, but the others might be a little more tricky. Phil Hibbs. -- Don't you just hate self-referential sigs? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

[sqlite] Error: no such table on .import

varchar(4) , verwe varchar(1) , vagrp varchar(3) , statu varchar(1) , sttag varchar(8) , strat varchar(6) , batchno varchar(3) ); Any idea why I'm getting no such table? Phil Hibbs. -- Don't you just hate self-referential sigs? ___ sqlite-users mailing

Re: [sqlite] Error: no such table on .import

because of the semicolon following the table name in your .import - command. Remove it. Yes, I was just about to reply saying I'd spotted that. Funny how after half an hour of scratching your head, you post to a mailing list and then spot it immediately. Thanks and apologies. Phil Hibbs

[sqlite] Cloning a database to memory

Is there an easy way of opening a SQLite database and cloning it to an in-memory database? Cloning a database in a file is easy, you just copy the file. It would be nice if I could just copy a file into memory just as easily. Phil Hibbs. -- Don't you just hate self-referential sigs

Re: [sqlite] Cloning a database to memory

http://www.sqlite.org/backup.html Awesome, that means an application could use SQLite both for its save file storage mechanism, and for manipulating its data in memory while it is running, dumping it back out to disk when it's finished. Thanks. Phil Hibbs. -- Don't you just hate self