> On Nov 21, 2016, at 10:08 AM, John R. Sowden <jsow...@americansentry.net> > wrote: > > Thank you all for your answers and direction for further information. > Hopefully, I will not bring these subjects up again. :)
Some of what you’re asking applies to any SQL database. The SQLite docs do include a reference to its SQL syntax (since no two databases speak exactly the same dialect of SQL) but they're not intended to teach you how to use SQL, or relational databases. So if you’re coming from a very different type of database like dBase, there’s a lot of basic stuff to [re]learn that the SQLite website sort of assumes you already know! I suggest looking for a book or a tutorial website to learn the basics of relational databases and SQL. If creating tables was a roadblock, I guarantee you’re going to be perplexed by things like joins. I learned SQLite ten+ years ago via an O’Reilly book, which might still be in print. I’m sure there are others. If you use a general relational-database book, be aware that the main difference between SQLite and other SQL databases is that it largely ignores column types and widths: you can put any type of value into any column (sort of like how in Python or JavaScript you can put any type of value into any variable), and you don’t need to specify a column width because SQLite can store any length of string into a column (again, like strings in most modern languages.) Oh, also, if you don’t already know about it, the `sqlite3` command-line tool is invaluable for learning to use SQLite, since it lets you try out commands and queries interactively. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
