On 22 Nov 2016, at 5:03pm, John R. Sowden <jsow...@americansentry.net> wrote:
> Thank you, but I am currently in the early learning phase of sql databases > and the sql language. I am starting with Sqlite due to its relative > simplicity, and moving on to H2 to integrate it into Libre Office. It's > commands like analyze that I have never heard of and need to become familiar > with. In the mean time I am reading the Sqlite mail list, understanding > about 40% of it. There seems to be a lot of sql tutorials on the web. > W3schools seems to be popular, so I am trying it. W3Schools is an excellent resource for learning stuff and trying to remember how to do some little thing. At this stage in your learning remember each time you encounter information to figure out if this is SQL -- which is likely to work in all SQL engines -- or SQLite-only. Each SQL engine has its own weird things which work only in that one version of SQL. For instance the "SELECT" command is for all implementations of SQL, but the "ANALYZE" command works only in SQLite, and the "ALTER INDEX" command works only in SQL SERVER. You can learn lots about how to use SQLite from a web site intended for some other implementation of SQL. But you may also learn a couple of things that just don't work in SQLite. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
