Script File 3

Script started on Wed 20 Sep 2017 02:32:58 PM EDT
pi:~/public_html/coursework/isc496/assignments/a4> sqlite3 test1.bin

SQLite version 3.11.0 2016-02-15 17:29:24
Enter ".help" for usage hints.
sqlite> select * from english;
1|good
2|tomorrow
sqlite> select * from spanish;
1|bueno
2|manana
sqlite> insert into translate (en,fsp) values (2,2);
sqlite> select * from english join translate hjoin spanish;
1|good|1|1|1|1|bueno
1|good|1|1|1|2|manana
1|good|2|2|2|1|bueno
1|good|2|2|2|2|manana
2|tomorrow|1|1|1|1|bueno
2|tomorrow|1|1|1|2|manana
2|tomorrow|2|2|2|1|bueno
2|tomorrow|2|2|2|2|manana
sqlite> . mode column
sqlite> select * from english joing translate join spanish;
1           good        1           1           1           1           bueno     
1           good        1           1           1           2           manana    
1           good        2           2           2           1           bueno     
1           good        2           2           2           2           manana    
2           tomorrow    1           1           1           1           bueno     
2           tomorrow    1           1           1           2           manana    
2           tomorrow    2           2           2           1           bueno     
2           tomorrow    2           2           2           2           manana    
sqlite> .mode list
sqlite> select * from english .mode list
select * from english join translate join spanish;
   ...> ewhere spanish.lemxeme = bueno'bueno' and translate .sp = spanish i.id
   ...> and translate.en = senglish.id;
1|good|1|1|1|1|bueno
sqlite> and translate.en = english.id;
where spanish.lexeme = 'bueno' and translate.sp = spanish.id
select * from english join translate join spanish
.mode list
select * from english join translate join spanish
   ...> whe;
1|good|1|1|1|1|bueno
1|good|1|1|1|2|manana
1|good|2|2|2|1|bueno
1|good|2|2|2|2|manana
2|tomorrow|1|1|1|1|bueno
2|tomorrow|1|1|1|2|manana
2|tomorrow|2|2|2|1|bueno
2|tomorrow|2|2|2|2|manana
sqlite> ;select * from english join translate join spanish[1@l[1@e[1@x[1@e[1@m[1@e
   ...> select lexeme from english join translate join spanish
;select * from english join translate join spanish
and translate.en = english.id;
where spanish.lexeme = 'bueno' and translate.sp = spanish.id
select * from english join translate join spanish
where spanish.lexeme = 'bueno' and translate.sp = spanish.id
   ...> where spanish.lexeme = 'bueno' and translate.sp = spanish.id
select lexeme from english join translate join spanish
;select * from english join translate join spanish
and translate.en = english.id;
where spanish.lexeme = 'bueno' and translate.sp = spanish.id
and translate.en = english.id;
Error: ambiguous column name: lexeme
sqlite> and translate.en = english.id;
where spanish.lexeme = 'bueno' and translate.sp = spanish.id
select lexeme from english join translate join spanish
;select lexeme from english join translate join spanish[1@e[1@n[1@g[1@l[1@i[1@s[1@h[1@.
where spanish.lexeme = 'bueno' and translate.sp = spanish.id
select english.lexeme from english join translate join spanish
   ...> select english.lexeme from english join translate join spanish
and translate.en = english.id;
where spanish.lexeme = 'bueno' and translate.sp = spanish.id
   ...> where spanish.lexeme = 'bueno' and translate.sp = spanish.id
select english.lexeme from english join translate join spanish
and translate.en = english.id;
good
sqlite> and translate.en = english.id;
where spanish.lexeme = 'bueno' and translate.sp = spanish.id
select english.lexeme from english join translate join spanish[1@s[1@p[1@a[1@n[1@i[1@s[1@h
   ...> select spanish.lexeme from english join translate join spanish
and translate.en = english.id;
where spanish.lexeme = 'bueno' and translate.sp = spanish.id
   ...> where spanish.lexeme = 'bueno' and translate.sp = spanish.id
select spanish.lexeme from english join translate join spanish
and translate.en = english.id;
bueno
sqlite> .quit
pi:~/public_html/coursework/isc496/assignments/a4> exit

exit

Script done on Wed 20 Sep 2017 02:41:40 PM EDT