Script started on Wed 20 Sep 2017 02:22:47 PM EDT
[4mpi[24m:[1m~/public_html/coursework/isc496/assignments/a4[0m> sqlite3 test1.bin
SQLite version 3.11.0 2016-02-15 17:29:24
Enter ".help" for usage hints.
sqlite> insert into english (lexeme) values ('good');
sqlite> select * from english;
1|good
sqlite> insert into spanish values('bueno');[C[1P');[1P');[1P');[1P');[1P');b');i');e');n');[1P');[1P');[1P');[1P');b');u');e');n');o');[C[C[C
Error: table spanish has 2 columns but 1 values were supplied
sqlite> insert into spanish (lexeme) values([K ('bueno');
sqlite> select * from spanish)[K;
1|bueno
sqlite> .quit
[4mpi[24m:[1m~/public_html/coursework/isc496/assignments/a4[0m> sqlite[K[K[K[K[K[Kclear\[K
[3;J[H[2J[4mpi[24m:[1m~/public_html/coursework/isc496/assignments/a4[0m> sqlite3 test1.bin
SQLite version 3.11.0 2016-02-15 17:29:24
Enter ".help" for usage hints.
sqlite> .tables
english spanish translate
sqlite> select * from spanish[K[K[K[K[K[K[Kenglish;
1|good
sqlite> sles[Kc[K[K[Kelect all[K[K[K* from spanish;
1|bueno
sqlite> .schema translate
CREATE TABLE translate (
id integer primary key,
en integer not null,
sp integer not null,
foreign key(en) references english(id),
foreign key(sp) references spanish(id)
);
sqlite> insert into translate (en,fr[K[Ksp) values (1,1);
sqlite> insert into english (lexeme) values tomorrow[K[K[K[K[K[K[K[K)[K('tomorrow)[K');
sqlite> insert into spanish (lexeme) values ('manana');
sqlite> .quit
[4mpi[24m:[1m~/public_html/coursework/isc496/assignments/a4[0m> exit
exit
Script done on Wed 20 Sep 2017 02:32:31 PM EDT