Re: [sqlite] Command-line utility
http://www.sqlite.org/download.html scroll to "Precompiled Binaries for Windows" It runs just fine on 32 bit windows. Adam Hi, thanks, and yes I have these, but am specifically interested in the latest development trunk, which I don't think is included on this page in compiled form (unless I'm mistaken in which case please point me in the right direction). ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Command-line utility
http://www.sqlite.org/download.html scroll to "Precompiled Binaries for Windows" It runs just fine on 32 bit windows. Adam On Thu, Jul 11, 2013 at 12:20 PM, RSmith wrote: > Could someone send me a build with the current trunk of the command-line > utility for Windows 32Bit with the standard option set for testing purposes > please, or point me to where I can download it if a standard build already > exists. > Thanks! > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- VerifEye Technologies Inc. 905-948-0015x245 151 Whitehall Dr, Unit 2 Markham ON, L3R 9T1 Canada ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Command-line utility
Could someone send me a build with the current trunk of the command-line utility for Windows 32Bit with the standard option set for testing purposes please, or point me to where I can download it if a standard build already exists. Thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite command-line utility (was: manual? documentat ion?)
> What does the...
> "(one varchar(10), two smallint)"
> ...in the following example...
> "sqlite> create table tbl1(one varchar(10), two smallint);"
> ...mean/do?
It creates the table 'tbl1' shaped like this.
+-+
| one | two |
+-+
| | |
| | |
Don't worry too much about the 'varchar(10)' and 'smallint' for now.
Other databases use this but SQLite just ignores it (not *exactly* true,
it uses it in a subtle way).
Then put some data in it with the command:
INSERT INTO tbl1 VALUES('hello', 'world');
INSERT INTO tbl1 VALUES(1, 2);
+---+
| one | two |
+---+
| hello | world |
| 1 | 2 |
Once there is stuff in the table, inspect it with:
SELECT one, two FROM tbl1;
Or just grab one of the rows:
SELECT one, two FROM tbl1 WHERE one = 'hello';
There you go. Stick "database admin" on your resume. :)
Dan.
[sqlite] sqlite command-line utility (was: manual? documentation?)
Jon, you're awesome. Thank you! Wade, although your question isn't phrased like this, it seems to be "Where can I find good documentation on using SQL?" Whether you use the command-line, or are connecting to SQLite through PHP is irrelevant. The syntax for adding, deleting, modifying and viewing data is identical--you have to use basic SQL commands. The command-line utility simply lets you type your SQL statements directly. Ah! Okay... that makes sense now. I never imagined that the command-line utility used the same commands. One more question if I may: What does the... "(one varchar(10), two smallint)" ...in the following example... "sqlite> create table tbl1(one varchar(10), two smallint);" ...mean/do? wade - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
