-
Notifications
You must be signed in to change notification settings - Fork 2
/
fix_composer.sql
13 lines (13 loc) · 1.11 KB
/
fix_composer.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
-- Composer full text
UPDATE Songs SET composer='J. J. Rousseau. Arr. Lowell Mason, 1823' WHERE PageNum='145b';
UPDATE Songs SET composer='<i>Juvenile Harmony</i>, Arr. John Massengale, 1850' WHERE PageNum='306';
UPDATE Songs SET composer='Timothy Swan, 1785. Arr. Phil A. Tabor, 1988' WHERE PageNum='344';
UPDATE Songs SET composer='Thomas Jarman, 1812. Arr. Phil A. Tabor, 1988' WHERE PageNum='350';
UPDATE Songs SET composer='Pietro Guglielmi, 1772. Arr. White & Searcy, 1850' WHERE PageNum='361';
UPDATE Songs SET composer='Abraham Maxim, 1802. Arr. Absalom Ogletree, 1859' WHERE PageNum='371';
UPDATE Songs SET composer='Samuel Wakefield, Arr. Silas W. Kay, 1855' WHERE PageNum='449';
UPDATE Songs SET composer='J. P. Webster, Arr. B. F. White, 1869' WHERE PageNum='451';
UPDATE Songs SET composer='John Wilson, 17th century. Arr. Richard L. DeLong, 1988' WHERE PageNum='510';
UPDATE Songs SET composer='Joseph Stone, 1793. Arr. A. A. Blocker, 1959' WHERE PageNum='528';
UPDATE Songs SET composer='<i>Rudiments of Music</i>, ca. 1787' WHERE PageNum='222';
UPDATE Songs SET composer='Arr. from Daniel Read, 1785' WHERE PageNum='467';