Difference between revisions of "Emilysimso Week 6"
From LMU BioDB 2015
Emilysimso (Talk | contribs) (Created page with "==Questions to Answer # DDL (create table) statements #* # sed command sequences #*cat application.txt | sed "s/^/insert into application2 (id, letter1, name, truefalse1, true...") |
Emilysimso (Talk | contribs) (Adding starting statements/sequences) |
||
| Line 1: | Line 1: | ||
| − | ==Questions to Answer | + | ==Questions to Answer== |
# DDL (create table) statements | # DDL (create table) statements | ||
| − | #* | + | #* create table application3 (ApplNo int, ApplType varchar, SponsorApplicant varchar, MostRecentLabel varchar, AvailableFlag varchar, CurrentPatent varchar, Flag int, ActionType varchar) |
# sed command sequences | # sed command sequences | ||
| − | #*cat application.txt | sed "s/^/insert into | + | #*cat application.txt | sed "s/^/insert into application3 (ApplNo, ApplType, SponsorApplicant, MostRecentLabel, AvailableFlag, CurrentPatent, Flag, ActionType) values (/g" | sed "s/.$/);/g" | sed "s/False/&,/g" |
Revision as of 19:05, 10 October 2015
Questions to Answer
- DDL (create table) statements
- create table application3 (ApplNo int, ApplType varchar, SponsorApplicant varchar, MostRecentLabel varchar, AvailableFlag varchar, CurrentPatent varchar, Flag int, ActionType varchar)
- sed command sequences
- cat application.txt | sed "s/^/insert into application3 (ApplNo, ApplType, SponsorApplicant, MostRecentLabel, AvailableFlag, CurrentPatent, Flag, ActionType) values (/g" | sed "s/.$/);/g" | sed "s/False/&,/g"
