Good evening gentlemen, I read the post: http://linuxgizmos.com/ringing-in-2017-with-90-hacker-friendly-single-board-computers/ which lists a number of SBC. I was interested, but the info in the table was lacking. The article also left out much of what I considered "Interesting" information. It seems to be more like a windowz PC sales ad. So, I decided to follow all the links and get the specs on the boards more thoroughly, and place them into an sqlite database, for searchability. Now, I'm no sql expert, but I have tried to learn and get this stuff correct, so please bear with my inadequacy.
# ALTER TABLE processors ADD CONSTRAINT bit NOT NULL Error: near "CONSTRAINT": syntax error # ALTER TABLE processors DROP bit; Error: near "DROP": syntax error I expected that both of the above would add the constraint. # SELECT boards.*,processors.*,storage.emmc FROM processors INNER > JOIN storage ON processors.board = storage.board; Error: no such table: boards # .schema CREATE TABLE boards( board varchar(30) PRIMARY KEY NOT NULL, price SMALLINT NOT NULL, vendor varchar(27) NOT NULL, oses varchar(32)); ... I expected that the table boards would exist. I also can't figure out how to join 3 tables, each on the board column. # SELECT processors.*,storage.* FROM processors INNER JOIN storage ON > processors.board = storage.board WHERE processors.board LIKE "%Rose%"; Roseapple Pi Actions S500 4x A9 @ 1.6GHz PowerVR SGX544 256MB0 Roseapple Pi 4GB eMMC 0 0 0 0 I wanted the board section of both tables to be joined and the one of them displayed (they have to be identical to join right?), not to be repeated, one after the other. Thank you in advance, David _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
