Run script to update course instructors
Closed this issue · 1 comments
buckyroberts commented
Run a command to update all course instructors to bucky (user ID: 1)
dmugtasimov commented
was
thenewboston=> select id, instructor_id from university_course;
id | instructor_id
-----+---------------
1 | 1
3 | 38
4 | 38
5 | 38
6 | 38
7 | 38
8 | 38
9 | 38
10 | 38
11 | 38
12 | 38
13 | 38
14 | 38
15 | 38
16 | 38
17 | 38
18 | 38
19 | 38
20 | 38
21 | 38
23 | 38
24 | 38
25 | 38
26 | 38
27 | 38
28 | 38
29 | 38
32 | 38
31 | 38
37 | 38
30 | 38
33 | 38
34 | 38
35 | 38
36 | 38
38 | 38
39 | 38
40 | 38
41 | 38
42 | 38
43 | 38
44 | 38
45 | 38
46 | 38
47 | 38
48 | 38
49 | 38
50 | 38
51 | 38
52 | 38
53 | 38
54 | 38
55 | 38
56 | 38
57 | 38
58 | 38
59 | 38
60 | 38
61 | 38
62 | 38
63 | 38
64 | 38
65 | 38
66 | 38
67 | 38
68 | 38
69 | 38
70 | 38
71 | 38
72 | 38
73 | 38
74 | 38
75 | 38
76 | 38
77 | 38
78 | 38
79 | 38
80 | 38
81 | 38
82 | 38
83 | 38
84 | 38
86 | 38
87 | 38
91 | 38
93 | 38
94 | 38
95 | 38
96 | 38
97 | 38
98 | 38
99 | 38
100 | 38
101 | 38
102 | 38
103 | 38
104 | 38
105 | 38
106 | 38
107 | 38
108 | 38
109 | 38
110 | 38
111 | 38
112 | 38
113 | 38
114 | 38
115 | 38
116 | 38
117 | 38
118 | 38
119 | 38
120 | 38
(113 rows)updated:
thenewboston=> update university_course set instructor_id = 1;
UPDATE 113