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