Emilysimso Week 6
From LMU BioDB 2015
Revision as of 19:05, 10 October 2015 by Emilysimso (Talk | contribs) (Adding starting statements/sequences)
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"
