> 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.