1
00:00:00,000 --> 00:00:02,405
>> [MUSIC PLAYING]

2
00:00:02,405 --> 00:00:10,439

3
00:00:10,439 --> 00:00:11,980
DAVID Malan: Omni jure, hoc est CS50.

4
00:00:11,980 --> 00:00:13,740
Hoc fine hebdomadis octo.

5
00:00:13,740 --> 00:00:15,887
Et nunc, nos satus
Utinam impleatur in aliqua pieces

6
00:00:15,887 --> 00:00:17,720
cum venit ad aedificationem
quae in textus.

7
00:00:17,720 --> 00:00:20,020
Sic revocare quod die lune
nos consumere multum tempus

8
00:00:20,020 --> 00:00:22,530
in PHP, quod haec dynamica
programming lingua

9
00:00:22,530 --> 00:00:26,872
nobis permittit ut output, inter alia
sunt et aliae huiusmodi regulariter HTML content

10
00:00:26,872 --> 00:00:27,830
ut videam te.

11
00:00:27,830 --> 00:00:30,871
Sed quomodo non respexit
iens congregem indicarent.

12
00:00:30,871 --> 00:00:34,477
Nam fere de eximius
interesting websites vos saluto hodie

13
00:00:34,477 --> 00:00:36,560
habent quandam database
tergo finem iudicium

14
00:00:36,560 --> 00:00:39,540
Facebook certe reponit lots of notitia
de omnibus nobis et omnibus thesauris Gmail

15
00:00:39,540 --> 00:00:40,210
tui emails.

16
00:00:40,210 --> 00:00:44,150
>> Itaque non modo multis aliis locis
static content quod informational.

17
00:00:44,150 --> 00:00:45,640
Suus 'vere admodum quodammodo.

18
00:00:45,640 --> 00:00:48,480
Praebere input, it updates
paginis pro aliis.

19
00:00:48,480 --> 00:00:50,620
Vos adepto nuntius mittis
nuncia perferentes, et sic de aliis.

20
00:00:50,620 --> 00:00:54,250
Hodie nobis propius
in lumine collustrata of a project

21
00:00:54,250 --> 00:00:57,330
ut youll 'valebant introire in animam next
week, CS50 Oeconomi, quae

22
00:00:57,330 --> 00:01:00,509
Omnino habiturus aedificabitis
C in re, sed in PHP.

23
00:01:00,509 --> 00:01:02,550
A website quod spectat
paululum quippiam huius rei simile

24
00:01:02,550 --> 00:01:05,810
quod permittit ad emendum et vendendum
nervum quod sunt in actu,

25
00:01:05,810 --> 00:01:09,044
iens ad hauriendam super reale tempus,
de stirpe data Yahoo Oeconomi.

26
00:01:09,044 --> 00:01:11,960
Ita demum enim tu
illusio pro te et pro users

27
00:01:11,960 --> 00:01:14,550
uos etiam emere et vendere
ligno et adquirendi prope realis tempus

28
00:01:14,550 --> 00:01:16,800
updates, administrandi
portfolio, quae omnia

29
00:01:16,800 --> 00:01:20,310
est iens ut postulo habens,
tandem a database users.

30
00:01:20,310 --> 00:01:23,330
>> Igitur in verbis
praesertim si in alieno fideles non

31
00:01:23,330 --> 00:01:25,670
eximius familiar cum computatrum
scientia vel databases, quid

32
00:01:25,670 --> 00:01:30,790
scis esse database
Nunc, in terminis ubi indicat?

33
00:01:30,790 --> 00:01:32,300
Quid est?

34
00:01:32,300 --> 00:01:36,882
Quomodo te describant eam
ad roommate propinquo aut amico interfectis?

35
00:01:36,882 --> 00:01:40,100
>> AUDITORES: [tacita]
notitia [tacita]

36
00:01:40,100 --> 00:01:44,430
>> DAVID Malan: ergo, a album of notitia,
aut index indicium store--

37
00:01:44,430 --> 00:01:47,160
vos vires volo ut congregem
aliquid ut aperias.

38
00:01:47,160 --> 00:01:50,190
Et quid users
consortia cum illis habuerint?

39
00:01:50,190 --> 00:01:53,160
Si vestri 'a user Facebook
Gmail, quae sunt characteres

40
00:01:53,160 --> 00:01:54,940
users quod omnes?

41
00:01:54,940 --> 00:01:58,530
Ut quid sit de
Spreadsheet columnas in quibus

42
00:01:58,530 --> 00:01:59,390
nunc commemorare monstraret ultimum tempus?

43
00:01:59,390 --> 00:02:01,140
Quia iterum, potes
cogitant de database

44
00:02:01,140 --> 00:02:05,810
ut vere adamasset Excel file aut Google
Spreadsheet vel Apple Numbers file.

45
00:02:05,810 --> 00:02:08,280
>> Quid censes
Cogitate cum ACL

46
00:02:08,280 --> 00:02:11,290
Quid habent?

47
00:02:11,290 --> 00:02:11,790
Quid est?

48
00:02:11,790 --> 00:02:12,470
>> AUDITORES: nomen Iulo.

49
00:02:12,470 --> 00:02:13,303
>> DAVID Malan: A nomine.

50
00:02:13,303 --> 00:02:16,840
Si ergo nomen, sicut David Malan
esset aliquod nomen user.

51
00:02:16,840 --> 00:02:17,980
Quid aliud a user est?

52
00:02:17,980 --> 00:02:18,770
>> AUDITORES: An ID.

53
00:02:18,770 --> 00:02:19,561
>> DAVID Malan: An ID.

54
00:02:19,561 --> 00:02:23,320
Atque, ut an ID numero cervices vestras sicut Harvard
Aut ID ID Yale Net vel aliquid huiusmodi.

55
00:02:23,320 --> 00:02:24,923
A user quid aliud habes?

56
00:02:24,923 --> 00:02:25,890
>> AUDITORES: Password.

57
00:02:25,890 --> 00:02:29,240
>> DAVID Malan: A password, maybe an
address, maybe a phone number, maybe

58
00:02:29,240 --> 00:02:30,050
an email oratio.

59
00:02:30,050 --> 00:02:32,640
Ita illic 'hoc agros gibbum
quaedam ex imperium posset spiralibus

60
00:02:32,640 --> 00:02:34,760
cito mox ut vos satus
intelligamusque, oh, lets 'thesaurizantes hoc

61
00:02:34,760 --> 00:02:36,190
et hoc melius condere.

62
00:02:36,190 --> 00:02:37,657
>> Unde etiam non videri?

63
00:02:37,657 --> 00:02:39,740
Sic conversus cogitavi, in mentalis exemplar
habere enim hodie sicut et nos

64
00:02:39,740 --> 00:02:42,320
dive in actu SQL,
Query Language exstructa,

65
00:02:42,320 --> 00:02:44,186
id est similis database.

66
00:02:44,186 --> 00:02:45,310
Suus 'iustus ordines columnarum.

67
00:02:45,310 --> 00:02:48,309
Et vos can imaginari Google Spreadsheets
aut alia progressio.

68
00:02:48,309 --> 00:02:52,130
Sed quid de MySQL key, quod est
database software iens uti

69
00:02:52,130 --> 00:02:54,920
gratis palam
available-- Facebook usus

70
00:02:54,920 --> 00:02:59,200
et sexcenta alia websites--
database recondit quae relative.

71
00:02:59,200 --> 00:03:01,770
Et a relativis database
justis modis praestante Domino qui litteram

72
00:03:01,770 --> 00:03:03,672
reponit data in ordines columns.

73
00:03:03,672 --> 00:03:04,630
Sed quia tam simplex.

74
00:03:04,630 --> 00:03:07,230
>> Ita etiam quod tale onus
vos vires have plerumque audivit

75
00:03:07,230 --> 00:03:08,271
est respectiva database.

76
00:03:08,271 --> 00:03:10,929
Et subter cucullo eam
data in thesauris ordines columnarum.

77
00:03:10,929 --> 00:03:12,970
Et Oraculum mandat a
multam pecuniam facere,

78
00:03:12,970 --> 00:03:15,550
cum MySQL criminibus
nihil pro eodem.

79
00:03:15,550 --> 00:03:18,790
Itaque nobis daturus SQL
saltem quatuor operationibus.

80
00:03:18,790 --> 00:03:23,190
Facultas eligere data, sicut legitur
data interserunt delete, et update data.

81
00:03:23,190 --> 00:03:25,525
Aliis verbis, qui sunt
realiter key quatuor operationibus

82
00:03:25,525 --> 00:03:28,950
quae passurus mutare
effercio in illis ordines columns.

83
00:03:28,950 --> 00:03:33,250
>> Tool ut puteus 'uti hodie praesertim
atque in ea discere SQL

84
00:03:33,250 --> 00:03:34,627
rursum vocavit PHP MyAdmin.

85
00:03:34,627 --> 00:03:35,460
Suus 'web substructio tool.

86
00:03:35,460 --> 00:03:38,200
Total coincidentia quod
scriptum in PHP.

87
00:03:38,200 --> 00:03:42,400
Quod suus 'iens ut daret nobis graphice
user interface ut possimus etiam

88
00:03:42,400 --> 00:03:46,054
create isti ordines columns
et loquere eis via code.

89
00:03:46,054 --> 00:03:47,970
Itaque nunc tincidunt
quod puto is ingenue

90
00:03:47,970 --> 00:03:51,000
genus of fun in processus
post tergum aedificare websites,

91
00:03:51,000 --> 00:03:54,580
partibus users non
Vides certe non curant,

92
00:03:54,580 --> 00:03:56,170
quia ut 'magis data deferretur.

93
00:03:56,170 --> 00:03:59,570
Ita a simili C
paulo minus quasi PHP,

94
00:03:59,570 --> 00:04:04,954
SQL, aut a quo se fulciat database
SQL, habet saltem haec notitia typus

95
00:04:04,954 --> 00:04:05,870
et ligaturas aliorum.

96
00:04:05,870 --> 00:04:08,107
CHAR, VARCHAR, INT, BIGINT,
DECIMAL et Datetime.

97
00:04:08,107 --> 00:04:09,940
Et illic 'a toto
fasciculum aliis features,

98
00:04:09,940 --> 00:04:11,940
sed faciamus hoc
via actu exemplum.

99
00:04:11,940 --> 00:04:16,450
>> Im 'iens ut iret in CS50 IDE
ubi praemisso me initium

100
00:04:16,450 --> 00:04:19,372
et Ive 'quoque divertit ad virum pro URL
hoc tool vocavit PHP MyAdmin.

101
00:04:19,372 --> 00:04:22,580
In problemate septem, dicam
prorsus ut vos ad hoc interface

102
00:04:22,580 --> 00:04:23,200
etiam.

103
00:04:23,200 --> 00:04:25,640
In summo sinistro cornu,
animadvertimus dicit praelegere.

104
00:04:25,640 --> 00:04:27,610
Et ut iustus significat quod
in antecessum, me creatum saeculum

105
00:04:27,610 --> 00:04:31,360
inane database vocatur lecture
nullum tamen in spreadsheets.

106
00:04:31,360 --> 00:04:32,600
Nulla ordines columnarum.

107
00:04:32,600 --> 00:04:34,308
Quia prima
res erant 'iens ut facere

108
00:04:34,308 --> 00:04:37,100
satus est creare a mensa
quod suus 'iens congregem nostri users.

109
00:04:37,100 --> 00:04:39,100
>> Ita, ad litteram super
huc rectus sum

110
00:04:39,100 --> 00:04:42,070
nunciatura database
Volo tabulam appellari only.

111
00:04:42,070 --> 00:04:44,845
Et hoc est quod lima
ut congregem omnes meae indicia.

112
00:04:44,845 --> 00:04:45,720
Et quot columnae?

113
00:04:45,720 --> 00:04:47,740
Sed videamus iam custodiunt illud simplex.

114
00:04:47,740 --> 00:04:51,855
EGO iustus volo ut congregem
nomen usoris a user.

115
00:04:51,855 --> 00:04:53,020
Puteus 'satus parva.

116
00:04:53,020 --> 00:04:55,370
Sic volo columnas binas conlocantes total.

117
00:04:55,370 --> 00:04:57,360
Ibo et praemittat click Go.

118
00:04:57,360 --> 00:04:59,210
Et tunc, pro his
columnas, quod Im 'iens

119
00:04:59,210 --> 00:05:04,576
si hoc ad do-- internet
cooperates-- omni iure,

120
00:05:04,576 --> 00:05:05,950
ita dicturi sumus iterum experiri.

121
00:05:05,950 --> 00:05:09,180
Ego creaturus mensa dicitur
User duabus columnis click vade urna.

122
00:05:09,180 --> 00:05:10,520
Sed tamen teneo elit.

123
00:05:10,520 --> 00:05:12,065
Gratias tibi ago, optime factum.

124
00:05:12,065 --> 00:05:14,440
Omni jure, ita quid velimus
His igitur in columnis vocari?

125
00:05:14,440 --> 00:05:16,080
>> Ita fit, ut suus 'iens esse utetur.

126
00:05:16,080 --> 00:05:19,480
Et ideo dicuntur omnia video here-- et interface
ingenue gets paulo deformis eventually,

127
00:05:19,480 --> 00:05:21,270
Quondam vos satus typing in omnibus data.

128
00:05:21,270 --> 00:05:27,450
Sed quid est quod quaedam executiones
videtur inopinatus, Im 'creans columnas,

129
00:05:27,450 --> 00:05:29,977
sed habet stulte tool
projeceruntque in ordines

130
00:05:29,977 --> 00:05:31,560
ita ut quantum valet configurare haec quinae denae.

131
00:05:31,560 --> 00:05:33,550
Ita illic 'duo codicellos subter Name.

132
00:05:33,550 --> 00:05:36,180
Et unum ex istis agro
vis vocatur utetur nomen,

133
00:05:36,180 --> 00:05:38,000
notum autem vobis facio et regionibus ejus.

134
00:05:38,000 --> 00:05:40,340
>> Et nunc habeo eligere
data genera pro talibus supponunt.

135
00:05:40,340 --> 00:05:42,330
Et ideo, cum in Excel
et Google Spreadsheets,

136
00:05:42,330 --> 00:05:45,531
columnae sis, quod tu
Name iustus typus vel utetur hit Ingreditur.

137
00:05:45,531 --> 00:05:48,030
Maybe vos polluistis illud in perfrica frontem
tantum claritate, sed ut 'eam.

138
00:05:48,030 --> 00:05:50,140
Ne det speciem actui
generibus columnarum desuper iuxta mensuram.

139
00:05:50,140 --> 00:05:53,790
Nunc in Google Spreadsheets aut Praecedo, vobis
ut specificare quomodo data redditur.

140
00:05:53,790 --> 00:05:58,120
Non possent Forma menu, quod
dat speciem ostendere quasi pupa signum,

141
00:05:58,120 --> 00:05:59,900
annuntiate hoc sicut fluctuetur punctum valorem.

142
00:05:59,900 --> 00:06:01,990
>> Et simile est in spiritu
quod sumus acturi

143
00:06:01,990 --> 00:06:04,740
sed omnino ad vim
notitia est quoddam genus.

144
00:06:04,740 --> 00:06:07,750
Etsi iam pridem
dixit illic 'tantum a paucis data genera,

145
00:06:07,750 --> 00:06:11,120
illic 'actu
universus sors, et haerent

146
00:06:11,120 --> 00:06:12,910
in vario gradus specificity.

147
00:06:12,910 --> 00:06:14,970
Et quasi declinavérunt, vos
potest etiam facere somnium res

148
00:06:14,970 --> 00:06:17,520
sicut repono geometries
inside of a database.

149
00:06:17,520 --> 00:06:19,250
Vos can reponunt quae
sicut GPS coordinatas

150
00:06:19,250 --> 00:06:22,420
et invenies in actu, scilicet mathematice,
aliis locis, quae proxime.

151
00:06:22,420 --> 00:06:24,128
Sed erant 'iens ut
Custodies hujuscemodi cultum eximius simplex

152
00:06:24,128 --> 00:06:26,800
ascende huc,
sic dicti string genera.

153
00:06:26,800 --> 00:06:29,240
>> Itaque hic est index
totum fasciculum options.

154
00:06:29,240 --> 00:06:32,740
CHAR, VARCHAR, TINYTEXT,
MEDIUMTEXT, LONGTEXT.

155
00:06:32,740 --> 00:06:34,110
Genus et opibus nimiis.

156
00:06:34,110 --> 00:06:37,610
Et valde dolendum est, aliquid
videtur inopinatus ad C,

157
00:06:37,610 --> 00:06:40,120
est vere a chari CHAR.

158
00:06:40,120 --> 00:06:44,170
Si definias, in a database
quod vestri notitia type est CHAR,

159
00:06:44,170 --> 00:06:47,390
id quod sic suus
CHAR autem vel medietas est.

160
00:06:47,390 --> 00:06:49,630
Sed vos unctionem habetis definias
quot chars vis.

161
00:06:49,630 --> 00:06:51,636
Sic, quod suus a typicam
longitudine pro username?

162
00:06:51,636 --> 00:06:52,760
Est terminus typice?

163
00:06:52,760 --> 00:06:53,920
>> AUDITORES: [tacita]

164
00:06:53,920 --> 00:06:55,050
>> DAVID Malan: XVI maybe?

165
00:06:55,050 --> 00:06:55,990
Aliquid tale.

166
00:06:55,990 --> 00:06:57,948
Tu scis, retro in
die octavo solebat.

167
00:06:57,948 --> 00:07:00,289
Interdum suus 'XVI, interdum
illud etiam amplius quid faciant.

168
00:07:00,289 --> 00:07:02,080
Et sic, hoc non
dicit da mihi unum CHAR.

169
00:07:02,080 --> 00:07:04,730
Nam cum liber essem habent ad speciem
longitudo agri,

170
00:07:04,730 --> 00:07:07,402
et quasi, ut ita dicam XVI.

171
00:07:07,402 --> 00:07:08,610
Et hie est commercium.

172
00:07:08,610 --> 00:07:11,360
Itaque momento temporis videbis
hoc est unum,

173
00:07:11,360 --> 00:07:14,620
omnis username habet esse XVI characters.

174
00:07:14,620 --> 00:07:18,720
Sed exspecta paulisper M A N A L. Ergo si sermones illius
Ego tantum me usoris quinque

175
00:07:18,720 --> 00:07:23,070
quid vis ut database
XI notis ad alterum

176
00:07:23,070 --> 00:07:24,471
Ive 'reservatur spatium?

177
00:07:24,471 --> 00:07:25,220
Quid ageres?

178
00:07:25,220 --> 00:07:26,480
>> AUDITORES: [tacita]

179
00:07:26,480 --> 00:07:27,160
>> DAVID Malan: Yeah, iustus
facerent omnes null.

180
00:07:27,160 --> 00:07:28,290
Constitues eos spatia.

181
00:07:28,290 --> 00:07:30,816
Sed haud scio an vitio nullitatis infecta, ita a
multum backslash cyphris.

182
00:07:30,816 --> 00:07:33,190
Ita ab una parte, weve
nunc scitote esse username

183
00:07:33,190 --> 00:07:34,780
XVI esse quam moribus.

184
00:07:34,780 --> 00:07:37,590
Et flip latus est
Si voluissem diutur nomine

185
00:07:37,590 --> 00:07:39,940
aut voluit a vere diu
username sicut diabolus aliquos ex vobis

186
00:07:39,940 --> 00:07:44,840
guys habeamus in illud collegium vel
at Yale.edu, non habebis.

187
00:07:44,840 --> 00:07:47,177
Itaque hercule, si quid habes
semper descripserunt in website

188
00:07:47,177 --> 00:07:49,385
et vos adepto increpuit dicens
vestri password nimis diu

189
00:07:49,385 --> 00:07:52,710
aut username nimis diu, suus '
simpliciter quia a programmer, cum

190
00:07:52,710 --> 00:07:55,500
Vestibulum vel eius database,
placuit hoc corvi

191
00:07:55,500 --> 00:07:57,150
amplius quam verbis.

192
00:07:57,150 --> 00:08:00,580
>> Omnes ius, ita quod si
procedimus nominare?

193
00:08:00,580 --> 00:08:05,240
Usquequo debet a
typicam humana sit nomen Domini?

194
00:08:05,240 --> 00:08:07,492
Quot characteribus, XVI?

195
00:08:07,492 --> 00:08:09,450
Im 'coniciens accidisse potuimus
aliquem in hoc locus

196
00:08:09,450 --> 00:08:13,210
ubi per suum primum plus novissimis
nomen longior XVI characters.

197
00:08:13,210 --> 00:08:14,850
Quid melius quam ut XVII?

198
00:08:14,850 --> 00:08:17,040
XVIII?

199
00:08:17,040 --> 00:08:18,830
XXV?

200
00:08:18,830 --> 00:08:20,350
Maior?

201
00:08:20,350 --> 00:08:20,980
XXX?

202
00:08:20,980 --> 00:08:21,855
>> AUDITORES: [tacita]

203
00:08:21,855 --> 00:08:23,700
DAVID Malan: 5000, o Deus meus.

204
00:08:23,700 --> 00:08:26,309
Ita ut suus 'forsit honestam
superius vinctum dicemus.

205
00:08:26,309 --> 00:08:28,350
Atque hie illud genus habent
facere iudicium vocatio.

206
00:08:28,350 --> 00:08:30,400
Similem nihil hic recte respondetur.

207
00:08:30,400 --> 00:08:32,740
Infinitum non sit bene possibile,
quia sumus eventually

208
00:08:32,740 --> 00:08:34,781
iens have-- sumus
iens memoria elabuntur.

209
00:08:34,781 --> 00:08:36,909
Sic habemus facere
iudicium vocatio in aliquo puncto.

210
00:08:36,909 --> 00:08:41,010
>> Commune esset, exempli gratia,
use-- ad me et specificare CHAR here

211
00:08:41,010 --> 00:08:46,050
ut before-- CCLV erat litteram
evolvimus database on this software

212
00:08:46,050 --> 00:08:46,700
abhinc annos.

213
00:08:46,700 --> 00:08:48,575
Itaque homines multum
esset iustus dicunt, fine.

214
00:08:48,575 --> 00:08:49,420
CCLV est terminus.

215
00:08:49,420 --> 00:08:50,620
Lets iustus utor maximum.

216
00:08:50,620 --> 00:08:51,870
Et hoc est pulchellus ridiculum.

217
00:08:51,870 --> 00:08:55,060
Ut si dicas typing alicuius
nominare CC plus characters,

218
00:08:55,060 --> 00:08:56,140
quod paulo ridiculum.

219
00:08:56,140 --> 00:08:59,624
>> Sed recordare quia ASCII non
sola ratio characters.

220
00:08:59,624 --> 00:09:01,540
Et ita, maxime in a
sors Asiae languages

221
00:09:01,540 --> 00:09:04,248
ubi moribus possumus
exprimunt keyboards sicut dolor meus US

222
00:09:04,248 --> 00:09:08,209
keyboard, quamcunque characteribus actu
XVI levo bits pro octo scissionibus.

223
00:09:08,209 --> 00:09:10,250
Itaque, hoc actualiter
non est inconveniens quod omnia

224
00:09:10,250 --> 00:09:12,250
quod nos postulo magis
spatium si volumus fit

225
00:09:12,250 --> 00:09:16,252
characters maior quam ipsa US
centric ones weve tendebat discutere.

226
00:09:16,252 --> 00:09:17,460
Itaque opus superior.

227
00:09:17,460 --> 00:09:21,470
Nescio quid sit optimum,
sed est fere communem CCLV.

228
00:09:21,470 --> 00:09:22,700
XXV sentit humilis.

229
00:09:22,700 --> 00:09:23,857
XVI, XXXII humiliatus.

230
00:09:23,857 --> 00:09:25,690
I erraret ex parte
superioris.

231
00:09:25,690 --> 00:09:27,330
Sed illic negotiantur fortuna semper.

232
00:09:27,330 --> 00:09:31,902
Quod forte manifesta
trade off reservandi CCLV chars

233
00:09:31,902 --> 00:09:33,360
nam unumquemque in nomine meo database?

234
00:09:33,360 --> 00:09:34,230
>> AUDITORES: [tacita]

235
00:09:34,230 --> 00:09:34,510
>> DAVID Malan: Quid id est?

236
00:09:34,510 --> 00:09:35,430
>> AUDITORES: [tacita]

237
00:09:35,430 --> 00:09:37,138
>> DAVID Malan: Suus '
multus of memoria, vox?

238
00:09:37,138 --> 00:09:42,280
M-A-L-A-N. De quibus paulo ante vastata CCL
characters iustus congregem nomen meum

239
00:09:42,280 --> 00:09:46,000
defensione, sicut in casu aliquis
Longa est in ordine nominis.

240
00:09:46,000 --> 00:09:47,940
Quod videtur quasi indebitum tradeoff.

241
00:09:47,940 --> 00:09:52,040
>> Ita fit ut SQL,
hoc database lingua,

242
00:09:52,040 --> 00:09:55,480
aliquid actu sustinet
vocavit VARCHAR aut variabilis CHAR.

243
00:09:55,480 --> 00:09:59,390
Nisi quod in hoc genere
Non patitur te certo definias

244
00:09:59,390 --> 00:10:01,900
latitudo, sed potius variabilis latitudine.

245
00:10:01,900 --> 00:10:05,060
Et subtilius disserendo, a
maximum latitudo luminis fiat in agro.

246
00:10:05,060 --> 00:10:08,901
Et hoc est nomen quod potest
non amplius CCL litteris

247
00:10:08,901 --> 00:10:10,150
sed certe potest esse vel pauciores.

248
00:10:10,150 --> 00:10:11,733
Et ligula database futurum.

249
00:10:11,733 --> 00:10:14,860
Si in M ​​A N A L,
suus 'tantum iens ut quinque

250
00:10:14,860 --> 00:10:18,120
maybe sex bytes pari
a fluidumque null moribus,

251
00:10:18,120 --> 00:10:23,330
et non expendet addito
CCXLIX CCL aut superflue bytes.

252
00:10:23,330 --> 00:10:27,380
>> Et hoc videtur utique
profectos eos una cum ista nocturna fabula.

253
00:10:27,380 --> 00:10:29,140
Tamen illic 'semper tradeoff.

254
00:10:29,140 --> 00:10:33,024
Et hinc est, quia commune aut inmundum usoris
certum esse durum coded at XVI,

255
00:10:33,024 --> 00:10:34,940
et quod maybe non
ius vocent, quod maybe

256
00:10:34,940 --> 00:10:40,040
est, sed quid non
VARCHARs omnia?

257
00:10:40,040 --> 00:10:42,020
>> Sit pro ratione voluntas.

258
00:10:42,020 --> 00:10:46,200
Quid quod etiam pro omni agro reperire VARCHARs
cuius longitudo ante nescis

259
00:10:46,200 --> 00:10:48,180
si videtur, magnum iudicium

260
00:10:48,180 --> 00:10:50,482
Uti tantum spatium quantum
ad hoc opus est finis?

261
00:10:50,482 --> 00:10:51,271
>> AUDITORES: Slower.

262
00:10:51,271 --> 00:10:52,146
DAVID Malan: Speller?

263
00:10:52,146 --> 00:10:53,120
AUDITORES: Facit illud tardior?

264
00:10:53,120 --> 00:10:53,970
DAVID Malan: Oh, suus 'tardus.

265
00:10:53,970 --> 00:10:55,720
Bonum, quod suus 'fere semper
responsum, ingenue.

266
00:10:55,720 --> 00:10:56,520
Sicut quid tradeoff?

267
00:10:56,520 --> 00:10:58,570
Aut sumptuum, plus spatii
vel sumptuum, plus temporis.

268
00:10:58,570 --> 00:11:00,111
Sic in hoc casu, ut segnior causabitur.

269
00:11:00,111 --> 00:11:00,920
Quam ob causam?

270
00:11:00,920 --> 00:11:05,830
>> AUDITORES: [tacita]
determinans [tacita].

271
00:11:05,830 --> 00:11:06,640
>> DAVID Malan: Bonum.

272
00:11:06,640 --> 00:11:09,670
Ideo etiam ab revocaret
PSED5 ludentem cum hue aditum ferens

273
00:11:09,670 --> 00:11:12,750
ut dictionarii si ad
deducendae agroque diuidundo memoria aut vitaliter

274
00:11:12,750 --> 00:11:14,630
crescit quiddam, quod
possit actu esse tardus.

275
00:11:14,630 --> 00:11:16,963
Si vos have vocare malloc
subter cucullo et maybe

276
00:11:16,963 --> 00:11:19,610
id quod MySQL est, ita
nimirum ut sit.

277
00:11:19,610 --> 00:11:22,430
Quod si putas in via
vel etiam ad PSet--

278
00:11:22,430 --> 00:11:26,340
duo weeks, cum nos fecit similis
binariae search etiam quaestionis,

279
00:11:26,340 --> 00:11:30,690
nisi de rebus singulis
in omni verbo et in columna database

280
00:11:30,690 --> 00:11:33,690
est prorsus idem tempus etiam
Si iis notis totum fasciculum

281
00:11:33,690 --> 00:11:37,390
blank est possis
temere accessum in vestri notitia, ius?

282
00:11:37,390 --> 00:11:40,310
>> Si scitis quoniam omnis
sermo XVI characters away,

283
00:11:40,310 --> 00:11:46,460
monstratorem possis numeris ita
loquere et XVI Concede nobis, XXXII, XLVIII, LXIV,

284
00:11:46,460 --> 00:11:49,589
et vos can iustus salire
statim usura arithmetica

285
00:11:49,589 --> 00:11:51,130
aliquibus verbis in database.

286
00:11:51,130 --> 00:11:54,280
Si suus 'a VARCHAR,
sed quid facere debeam?

287
00:11:54,280 --> 00:11:55,960
>> [PHONE carmina tinnula pelle]

288
00:11:55,960 --> 00:11:58,680
>> Si suus 'VARCHAR tu
non potest utor temere accessum.

289
00:11:58,680 --> 00:12:01,341
Tu vel quaerere?

290
00:12:01,341 --> 00:12:01,840
Yeah?

291
00:12:01,840 --> 00:12:03,240
>> AUDITORES: [tacita]

292
00:12:03,240 --> 00:12:04,310
>> DAVID Malan: Respice
whole-- per vestigium

293
00:12:04,310 --> 00:12:06,518
per totum album
quaerunt quid verisimile?

294
00:12:06,518 --> 00:12:08,356
Qualem singularem?

295
00:12:08,356 --> 00:12:09,230
AUDITORES: [tacita]

296
00:12:09,230 --> 00:12:11,105
DAVID Malan: Vultus
pro null Terminators

297
00:12:11,105 --> 00:12:13,637
quod demarcate separationem verborum.

298
00:12:13,637 --> 00:12:15,720
Sic conversus cogitavi, in tradeoff, et
illic 'haud recta verba respondet.

299
00:12:15,720 --> 00:12:18,380
Sed hoc est ubi, praesertim
cum multis users evadere

300
00:12:18,380 --> 00:12:21,700
et onus tuum servientibus, in
Infinitus numerus est populi usura is gets excelsum,

301
00:12:21,700 --> 00:12:23,650
haec sunt actu nontrivial decretisque iugulasset.

302
00:12:23,650 --> 00:12:26,640
Itaque haec possit, sed
lets volumine descendit ad dexteram

303
00:12:26,640 --> 00:12:27,332
here.

304
00:12:27,332 --> 00:12:30,290
Facta est columnas duas
ubi nos habemus ad iudicium vocas.

305
00:12:30,290 --> 00:12:35,170
Facit sensu sineret usoris
nominare, a user scriptor username vel a user scriptor

306
00:12:35,170 --> 00:12:36,370
nominabo discrepent, nullas esse?

307
00:12:36,370 --> 00:12:37,610
Id est, sicut blank.

308
00:12:37,610 --> 00:12:40,360
Sentit paulo ridiculum, sic Im
Non coercere boxes.

309
00:12:40,360 --> 00:12:42,670
Sed evenit in a
database, possis dicere,

310
00:12:42,670 --> 00:12:44,620
optionally aliquis potest habere valorem.

311
00:12:44,620 --> 00:12:47,180
Huic agmini non habet
ut vere sit ibi.

312
00:12:47,180 --> 00:12:48,570
>> Erat hic gutta descendit menu.

313
00:12:48,570 --> 00:12:50,810
Et nota adhuc sum
in primo versu,

314
00:12:50,810 --> 00:12:52,520
ita Im 'sermo super username nunc.

315
00:12:52,520 --> 00:12:56,290
Et si contigerit ut datorum
dissimilis simplex mere spreadsheet,

316
00:12:56,290 --> 00:12:58,520
has validus features vocatur index.

317
00:12:58,520 --> 00:13:02,600
Et est haec via dicens
database in antecessum quia humana

318
00:13:02,600 --> 00:13:03,900
culus mundior sum quam tu.

319
00:13:03,900 --> 00:13:10,430
>> Scio quid genera queries, select
vel deleri, vel inserere vel update,

320
00:13:10,430 --> 00:13:13,182
Codex meus ad finem
inciderint in hoc database.

321
00:13:13,182 --> 00:13:14,390
Volo legere multum elit.

322
00:13:14,390 --> 00:13:15,681
Volo inserere multum elit.

323
00:13:15,681 --> 00:13:17,530
Volo constanter
delete multum data.

324
00:13:17,530 --> 00:13:21,520
Si fuero iudicatus scio quod Im 'iens
accessu agrum quasi qui utetur nomen multum,

325
00:13:21,520 --> 00:13:24,770
I can praeverure dic
datorum Scio plus quam tu

326
00:13:24,770 --> 00:13:29,220
et volo ut decretum
fers ut ferri decet index hoc campo.

327
00:13:29,220 --> 00:13:33,200
Ubi indexing quispiam agrum vel column
significat quod database in antecessum

328
00:13:33,200 --> 00:13:37,040
Ut mutuo acciperent ab aliquo ideas, sicut,
week quattuor et quinque et sex de CS50

329
00:13:37,040 --> 00:13:39,240
actu et aedificabo in generationem
vas quoddam velut linteum binariae search

330
00:13:39,240 --> 00:13:41,560
lignum vel aliquid
vulgo vocatur a B ligno

331
00:13:41,560 --> 00:13:43,410
ut discerent
in genere sicut CS124

332
00:13:43,410 --> 00:13:46,710
at Harvard, an algorithms class,
vel pluries alibi.

333
00:13:46,710 --> 00:13:49,570
>> Datorum et dolor
populus qui suggesserant, iussit fieri

334
00:13:49,570 --> 00:13:53,880
et instar sicco quam ut congregem
mensam notitia

335
00:13:53,880 --> 00:13:57,061
in memoria et ut searches
aliarum operationum sunt superessentialem ieiunium.

336
00:13:57,061 --> 00:13:58,060
Sed non facere.

337
00:13:58,060 --> 00:14:00,640
Non habetis esse ad operandam
linear search aut binariae search

338
00:14:00,640 --> 00:14:03,300
aut lectio aut merge sort
modi quicquam.

339
00:14:03,300 --> 00:14:06,590
Si autem id quod non datorum
it praevenire index in hoc campo.

340
00:14:06,590 --> 00:14:09,100
>> Potes videre, illic '
aliqua alia indicia

341
00:14:09,100 --> 00:14:11,010
dici potest repetere datorum.

342
00:14:11,010 --> 00:14:16,431
Quid sibi uult, si velim Unique
ex hoc menu, iustus intuitive?

343
00:14:16,431 --> 00:14:16,930
Yeah?

344
00:14:16,930 --> 00:14:17,889
>> AUDITORES: [tacita]

345
00:14:17,889 --> 00:14:19,930
DAVID Malan: Yeah,
username habet esse unicum.

346
00:14:19,930 --> 00:14:23,330
Hoc enim bonum et malum
database in website users?

347
00:14:23,330 --> 00:14:24,965
Donec ut sit singulare?

348
00:14:24,965 --> 00:14:25,880
Yeah, probabiliter.

349
00:14:25,880 --> 00:14:27,800
Si quod est scriptor quid
utimur stipes in agro,

350
00:14:27,800 --> 00:14:31,867
re vera non habentes
idem sentiunt aut eodem username.

351
00:14:31,867 --> 00:14:33,700
Non possimus habere
database imperatorium exeat, ut

352
00:14:33,700 --> 00:14:37,880
quod nunc in PHP codice vel alicujus linguae,
Non oportet enim Lorem

353
00:14:37,880 --> 00:14:41,490
ex necessitate hoc faciat username
existunt antequam nuntiet huc aliquis dominam register?

354
00:14:41,490 --> 00:14:46,690
Duo nomina non datorum
David or register Malans in hoc casu.

355
00:14:46,690 --> 00:14:50,030
>> Et quasi seorsum, quamvis
Menu sinit scriptis,

356
00:14:50,030 --> 00:14:54,550
quod unicum est index
iudex ad superessentialem ieiunium perficientur,

357
00:14:54,550 --> 00:14:56,100
sed etiam tuetur unici intelligentia.

358
00:14:56,100 --> 00:14:58,850
Et quod revertemur
alia duo intelliguntur in iustus momento.

359
00:14:58,850 --> 00:15:00,930
Interim, si ad
mea secundi ordinis, quae

360
00:15:00,930 --> 00:15:06,230
user nomen est, si definias
sit nomen singulare?

361
00:15:06,230 --> 00:15:09,550
Nequaquam ita fiat, quia potuit certe
have-- illic 'haud duo David

362
00:15:09,550 --> 00:15:11,050
Malans in hac exedra, plurimus amo.

363
00:15:11,050 --> 00:15:14,290
Sin aliter signetur nomine
ut profecto collisiones.

364
00:15:14,290 --> 00:15:16,130
>> Memento ut hash tabulae et alia huiusmodi.

365
00:15:16,130 --> 00:15:18,604
Et utique non
ut agri nomine singularis.

366
00:15:18,604 --> 00:15:21,270
Sic erant 'iustus iens ut relinquam
ut offendas, ruuntque, ruuntque, nihil.

367
00:15:21,270 --> 00:15:22,660
Et Im 'iens ut relinquam
omnia solus.

368
00:15:22,660 --> 00:15:25,035
Quidem, pleraque ex his agris
non curat habere.

369
00:15:25,035 --> 00:15:27,830
Et nisi hoc paratus sum,
si internet cooperatur,

370
00:15:27,830 --> 00:15:35,032
Salvum me click et nimis valde
paulatim enim database adepto salvari.

371
00:15:35,032 --> 00:15:37,240
Nunc revertar ad
interface, quae quidem,

372
00:15:37,240 --> 00:15:38,680
et impetum concitati ferre primo intuitu.

373
00:15:38,680 --> 00:15:42,450
Sed ego click facere
radices in divinis eloquiis Users at summo sinistram.

374
00:15:42,450 --> 00:15:47,630
Ego ibo huc click
User per defaltam illam

375
00:15:47,630 --> 00:15:50,180
faciat aliquam SQL, sed
magis illo momento.

376
00:15:50,180 --> 00:15:52,654
Hic mox recapitulando quid fecerim.

377
00:15:52,654 --> 00:15:55,320
Ne solliciti cernitis
Latin and mention of Swedish here.

378
00:15:55,320 --> 00:16:00,490
Illi sunt iustus default
occasus, quia MySQL primitus,

379
00:16:00,490 --> 00:16:04,000
aut PHP MyAdmin, unus ex duobus, accidit
Swedish scribi per populum.

380
00:16:04,000 --> 00:16:06,100
Sed ad propositum nostrum in proposito.

381
00:16:06,100 --> 00:16:08,280
>> Omnes ius, ita quod est
haec omnia interesting?

382
00:16:08,280 --> 00:16:13,050
Evenit, possum insert data
database in scribendo codice.

383
00:16:13,050 --> 00:16:15,940
Et ego pergam obvius
hic in file sum

384
00:16:15,940 --> 00:16:19,000
Cura ut obvius ire
hoc wired ad database, quod

385
00:16:19,000 --> 00:16:23,040
non statim, sed voluntatem
septem enim contrahere dicimur problemate.

386
00:16:23,040 --> 00:16:25,640
Im 'iens ut et vade
exequi query functio vocavit,

387
00:16:25,640 --> 00:16:28,730
quod si feceris, dabimus tibi problema
septem s distributio code, quod

388
00:16:28,730 --> 00:16:31,490
accipit saltem unam rationem,
quod iustum est si rumpat quis filum.

389
00:16:31,490 --> 00:16:33,460
A chorda SQL code.

390
00:16:33,460 --> 00:16:36,700
Sic te geras discere
scribere Structured Query Language.

391
00:16:36,700 --> 00:16:41,270
>> Si vis in ordine interseri novum
database quod aliquis cesserit

392
00:16:41,270 --> 00:16:47,600
forma ad codicem Opto litteram
scribere INSERT INTO users sequentibus

393
00:16:47,600 --> 00:16:52,800
agros: username,
comma nominamus bonis

394
00:16:52,800 --> 00:16:57,480
et nunc ego a te debeo insert
aliquid simile Malan, Illud autem lepidissimum,

395
00:16:57,480 --> 00:17:01,490
Unquote David Malan. Et nunc
iis qui ignorant SQL,

396
00:17:01,490 --> 00:17:07,830
quid ego uti uno quotes
inside of hoc viridi citharizatur?

397
00:17:07,830 --> 00:17:10,790

398
00:17:10,790 --> 00:17:13,040
Quid sit quod hic

399
00:17:13,040 --> 00:17:14,609
>> Ecce ego commixtionem utrarumque linguarum.

400
00:17:14,609 --> 00:17:18,099
Quaeris a PHP functio,
sed fit argumentum.

401
00:17:18,099 --> 00:17:21,740
Et ratio est, quia ipsa
scripta sunt in aliam quamdam linguam translatae vocavit

402
00:17:21,740 --> 00:17:23,500
SQL, Structured Query Language.

403
00:17:23,500 --> 00:17:27,940
Ita omnia quae ego
iustus highlighted hic

404
00:17:27,940 --> 00:17:30,380
hoc est ydioma SQL.

405
00:17:30,380 --> 00:17:36,290
Et quid uno quotes
sicut a velox sanitatem reprehendo?

406
00:17:36,290 --> 00:17:37,324
Et anteibit faciem tuam.

407
00:17:37,324 --> 00:17:37,990
Haerent tangite.

408
00:17:37,990 --> 00:17:41,590
Ita, quote, Unquote Malan Illud autem lepidissimum,
Unquote David Malan sunt modulationes uocum.

409
00:17:41,590 --> 00:17:45,210
Et iustus cogitare intuitive nunc,
nesciens quid scis C PHP,

410
00:17:45,210 --> 00:17:50,220
cur ita faciat, quod soleo
used pro duplici quotes constrictus esset?

411
00:17:50,220 --> 00:17:52,310
Quare non vis facere?

412
00:17:52,310 --> 00:17:52,810
Yeah?

413
00:17:52,810 --> 00:17:53,685
>> AUDITORES: [tacita]

414
00:17:53,685 --> 00:17:56,695

415
00:17:56,695 --> 00:17:57,570
DAVID Malan: Etiam.

416
00:17:57,570 --> 00:17:59,653
Quoniam Im 'iam usura
duplici quotes in via

417
00:17:59,653 --> 00:18:01,929
extra argumenti
ad PHP functio,

418
00:18:01,929 --> 00:18:03,470
Ego iustus interpres confundunt.

419
00:18:03,470 --> 00:18:04,860
Non sciunt, hi sunt?

420
00:18:04,860 --> 00:18:05,735
Istae simul ire?

421
00:18:05,735 --> 00:18:06,810
Istae simul ire?

422
00:18:06,810 --> 00:18:08,070
Itaque ego alternare instead.

423
00:18:08,070 --> 00:18:11,784
>> Aut tale possem,
backslash quote vel backslash quote.

424
00:18:11,784 --> 00:18:14,200
Ingenue, quod incipit
proficient unreadable et deformis.

425
00:18:14,200 --> 00:18:16,790
Sed quod consequi
idem pariter.

426
00:18:16,790 --> 00:18:19,760
>> Igitur, si hoc facere
quaero nunc videamus quid eveniat intellego.

427
00:18:19,760 --> 00:18:22,740
Im 'iens magis nunc perge
PHP codice executio quod

428
00:18:22,740 --> 00:18:24,610
is ubi youll ludere
in problemate septem,

429
00:18:24,610 --> 00:18:27,200
Im 'iens ut potius ite ad PHP MyAdmin.

430
00:18:27,200 --> 00:18:29,770
Et Im 'iens manually
ad tab SQL,

431
00:18:29,770 --> 00:18:31,580
Dimitte me zoom in interface.

432
00:18:31,580 --> 00:18:34,007
Ego autem in paste
res EGO iustus typed.

433
00:18:34,007 --> 00:18:36,090
Et color coding habet
mutavit aliquantulus frenum nunc,

434
00:18:36,090 --> 00:18:38,750
quia progressio formats
quae a paulo aliter.

435
00:18:38,750 --> 00:18:41,960
Sed nota quod feci
Ego dixi, inseres only.

436
00:18:41,960 --> 00:18:45,790
Mihi certum est ergo in commate
separantur parenthesized list duo

437
00:18:45,790 --> 00:18:48,850
agros quod volo inserere, et
tunc Ive 'litteram dixit valores

438
00:18:48,850 --> 00:18:51,510
secuti ab alio paren,
et tunc bini valores

439
00:18:51,510 --> 00:18:53,520
Volo plug-in et
nunc quia vobis mensuram bonam confersam

440
00:18:53,520 --> 00:18:55,010
Ponam in extremo semicolon.

441
00:18:55,010 --> 00:18:56,570
Et hoc non est C. PHP.

442
00:18:56,570 --> 00:18:59,970
Hanc ecce vobis SQL, et Im 'preteritus eam
licio substructio in hoc interface

443
00:18:59,970 --> 00:19:02,710
iustus iens ut dimittas me,
mox ut click vade

444
00:19:02,710 --> 00:19:08,060
hoc facere query de database
CS50 intus currit IDE.

445
00:19:08,060 --> 00:19:09,470
>> Et hoc est bonum.

446
00:19:09,470 --> 00:19:12,520
Notice quod dicitur uno ordine lignorum
inserta, abiit superessentialem ieiunium,

447
00:19:12,520 --> 00:19:15,190
0,0054 seconds inserere quod data.

448
00:19:15,190 --> 00:19:16,610
Itaque satis sanum sonat.

449
00:19:16,610 --> 00:19:19,350
It reformatted meum query
hic mihi videre

450
00:19:19,350 --> 00:19:21,730
in genere coloris coded version.

451
00:19:21,730 --> 00:19:24,540
Nunc autem si click
Browse, animadverto ut, etiam

452
00:19:24,540 --> 00:19:29,070
licet sit amet acervi super
velum nunc mensam tripertito.

453
00:19:29,070 --> 00:19:30,700
>> Itaque me fac alium.

454
00:19:30,700 --> 00:19:33,760
Pro hoc, ut dimittas me
ite ad tab SQL iterum.

455
00:19:33,760 --> 00:19:40,723
Et sicut hoc tempore ego inserere
Et in nomine eius gentes Rob Bowden Rob.

456
00:19:40,723 --> 00:19:42,330
Bowden.

457
00:19:42,330 --> 00:19:44,040
Lets click Save.

458
00:19:44,040 --> 00:19:46,140
Oops, potius ite.

459
00:19:46,140 --> 00:19:48,890
>> Browse click iterum, et
Habeo duas porticus nunc intendat.

460
00:19:48,890 --> 00:19:52,390
Et hoc est magis compositum
viam aperiens Google Spreadsheets

461
00:19:52,390 --> 00:19:54,010
et iustus typing in a row a column.

462
00:19:54,010 --> 00:19:57,070
Sed quid est, quod clavem
nunc habent syntax

463
00:19:57,070 --> 00:20:00,220
ut qui codicem scribere
tandem, potuimus actu

464
00:20:00,220 --> 00:20:01,790
quidam et hoc.

465
00:20:01,790 --> 00:20:05,380
Memini PHP subsidia
eximius global variabilium.

466
00:20:05,380 --> 00:20:08,415
>> Quid est inside of pupa
GET sign underscore in PHP?

467
00:20:08,415 --> 00:20:10,290
Cepimus a inviso unus
aut duos simplex exempla.

468
00:20:10,290 --> 00:20:15,640
Et in PSet6, habes memini salve
dot PHP quae utitur hoc variabilis.

469
00:20:15,640 --> 00:20:17,870
Quid agatur in fuerint ibi decem?

470
00:20:17,870 --> 00:20:21,015
Aut quid est illud?

471
00:20:21,015 --> 00:20:22,522
A paulo prolixius tendebatur.

472
00:20:22,522 --> 00:20:23,790
>> AUDITORES: [tacita]

473
00:20:23,790 --> 00:20:25,030
>> DAVID Malan: Suus 'a frigoribus nivis
semen array, quae

474
00:20:25,030 --> 00:20:27,714
est iustus a ludo viam dicentes an
array quod habet key valorem paria.

475
00:20:27,714 --> 00:20:28,880
Et claves non numerum.

476
00:20:28,880 --> 00:20:30,420
Haerent verba vel tangite.

477
00:20:30,420 --> 00:20:32,750
Et in specie, quod
sunt key valorem paria?

478
00:20:32,750 --> 00:20:35,110
Unde venerunt ad te?

479
00:20:35,110 --> 00:20:35,620
Paenitet?

480
00:20:35,620 --> 00:20:36,994
>> AUDITORES: [tacita]

481
00:20:36,994 --> 00:20:37,660
DAVID Malan: No?

482
00:20:37,660 --> 00:20:40,700
Ubi ea key
valorem paria venis?

483
00:20:40,700 --> 00:20:42,490
Iterum dico?

484
00:20:42,490 --> 00:20:44,610
Iterum?

485
00:20:44,610 --> 00:20:46,472
Ego solus auditus aliquid

486
00:20:46,472 --> 00:20:47,810
>> [LAUGHTER]

487
00:20:47,810 --> 00:20:49,042
>> Ut 'rectum, sic?

488
00:20:49,042 --> 00:20:50,435
>> AUDITORES: [tacita]

489
00:20:50,435 --> 00:20:52,560
DAVID Malan: Yeah, non
ex query filum.

490
00:20:52,560 --> 00:20:55,380
Quare si tempore rewind
cum lusimus cum Google

491
00:20:55,380 --> 00:20:59,600
et nos youve perrexerant ad Google.com VULNUS
search quaestio marcam q pares feles,

492
00:20:59,600 --> 00:21:03,550
Si igitur et hit Ingreditur
Google sunt implemented in PHP,

493
00:21:03,550 --> 00:21:07,017
PHP codice est, quod scripsit Google
haberet accessum ad pupa signum

494
00:21:07,017 --> 00:21:11,600
GET underscore inside of quod
dictus est a key valorem Q

495
00:21:11,600 --> 00:21:17,680
vocavit feles quae tunc potest uti
facere consuerant cum actu quaerere.

496
00:21:17,680 --> 00:21:20,860
>> Et sane quid Im 'iens
Nunc est redire ad PHP codice

497
00:21:20,860 --> 00:21:23,140
ut youll 'convertemini et videbitis quid magis in PSet7.

498
00:21:23,140 --> 00:21:25,440
Et pro plugging
in durum coded valores praebent qui magis

499
00:21:25,440 --> 00:21:27,630
non videtur quasi
motum website,

500
00:21:27,630 --> 00:21:30,680
Ego autem dedi tibi node
codice actu quid esset facturus.

501
00:21:30,680 --> 00:21:32,854
Qui separati estis in duas partes
quaestio notat hoc diligunt.

502
00:21:32,854 --> 00:21:34,270
Nescio quid sit maiusculas.

503
00:21:34,270 --> 00:21:37,390
Nescio quid sit
nomen est iens futurus,

504
00:21:37,390 --> 00:21:39,470
sed scio non possum
adferque vitaliter.

505
00:21:39,470 --> 00:21:43,420
>> Si 'scribens codice nunc
signum currit on Google servientibus,

506
00:21:43,420 --> 00:21:46,940
aut si huius salve dot
PHP, quod fit cum PSet6,

507
00:21:46,940 --> 00:21:48,650
Im 'iens ire ad
in query functio

508
00:21:48,650 --> 00:21:51,450
sicut printf, duas alias rationes.

509
00:21:51,450 --> 00:21:57,120
GET, quote, Unquote username,
et GET, quote, Unquote nomen.

510
00:21:57,120 --> 00:22:00,720
Et nunc illud attende quid
general structura est hic.

511
00:22:00,720 --> 00:22:03,320
Ive 'got a sinistris
manus manus pars of vocationem,

512
00:22:03,320 --> 00:22:05,480
hoc in query functio vocavit PHP.

513
00:22:05,480 --> 00:22:08,160
Adhuc habeo quod a primo
argumentum a filo text.

514
00:22:08,160 --> 00:22:11,000
>> Sed quod filo text est
scriptum est ydioma SQL.

515
00:22:11,000 --> 00:22:12,616
Et ingenue, non magno lingua.

516
00:22:12,616 --> 00:22:14,990
Lorem tantum loqui
formaliter hodie, vere.

517
00:22:14,990 --> 00:22:17,031
Et tunc in problemate
septem, illic 'relative

518
00:22:17,031 --> 00:22:18,800
paucis features quod sumus
iens leverage.

519
00:22:18,800 --> 00:22:22,530
Quaestio marcas, quamvis, plug in medium
a value plug in hic et alius valor

520
00:22:22,530 --> 00:22:23,130
here.

521
00:22:23,130 --> 00:22:26,010
Et notandum me praetermisisse
circa quote-- damn

522
00:22:26,010 --> 00:22:30,470
it-- circa quotation
signat etiam hac vice.

523
00:22:30,470 --> 00:22:34,930
Ive 'omittitur quotation
notas circum quaestio marcam,

524
00:22:34,930 --> 00:22:36,410
paenitet hoc tempore circum.

525
00:22:36,410 --> 00:22:38,870
>> Quid est hoc nisi
quaestio marcam pluma quod

526
00:22:38,870 --> 00:22:42,830
PHP tendit ad sustinere, et Ruby
Python et aliis linguis,

527
00:22:42,830 --> 00:22:45,730
hoc justis modis praestante Domino plug in aliqua
hinc aestimare scis quid?

528
00:22:45,730 --> 00:22:48,300
Vos instar sicco an uti
uno quotes aut duplum quotes.

529
00:22:48,300 --> 00:22:50,966
Cave ne pugnes contra me apud illos
intellectualiter INERS details.

530
00:22:50,966 --> 00:22:53,780
Sed fac illud recte
ut mea code is demum

531
00:22:53,780 --> 00:22:57,010
perficiendis et incolumes esse, quod
mox rationem habebit.

532
00:22:57,010 --> 00:23:00,460
>> Nunc quam multis argumentis totalis iustus
manifestum erit, est query functio captivitatis?

533
00:23:00,460 --> 00:23:05,240

534
00:23:05,240 --> 00:23:07,581
Quisque velit quam eligendam duo

535
00:23:07,581 --> 00:23:08,080
Tribus?

536
00:23:08,080 --> 00:23:10,001
Certus, quid?

537
00:23:10,001 --> 00:23:10,920
Quid tres?

538
00:23:10,920 --> 00:23:12,305
>> AUDITORES: [tacita]

539
00:23:12,305 --> 00:23:13,180
DAVID Malan: Etiam.

540
00:23:13,180 --> 00:23:14,610
Prima pars nervo.

541
00:23:14,610 --> 00:23:18,640
Secunda ratio est pupa signum
GET underscore bracket username.

542
00:23:18,640 --> 00:23:21,950
Et tertium argumentum est
idem, sed nomen.

543
00:23:21,950 --> 00:23:24,590
Ita in aliis verbis, nunc
si certo cognovero conpletam telam form

544
00:23:24,590 --> 00:23:27,149
quod habuit ad text agri,
unum usoris Register

545
00:23:27,149 --> 00:23:29,690
pro eius nomine, sicut
sicut videbis in website

546
00:23:29,690 --> 00:23:32,120
cum te adnotet pro
quidam website, hac fortitudine

547
00:23:32,120 --> 00:23:35,450
in dorso finis codice
reapse insertionem nunc

548
00:23:35,450 --> 00:23:37,220
in database.

549
00:23:37,220 --> 00:23:40,870
>> Nunc per oppositum, et ieiunium deinceps.

550
00:23:40,870 --> 00:23:43,840
Puta a user iam
logging in et vis

551
00:23:43,840 --> 00:23:48,860
PHP codice scribere coercens utrum
Sicut homo qui initium

552
00:23:48,860 --> 00:23:52,250
user quidem possis
pulchellus simplex uti syntax.

553
00:23:52,250 --> 00:23:55,832
Possis dicere velit, lets dicunt
astrum, astrum quo significat omnia.

554
00:23:55,832 --> 00:23:57,540
Non sciunt quae dixerim ego
volo ut iustus tribuo me

555
00:23:57,540 --> 00:24:01,585
omnes columnae de mensa
users ubi dicitur, quod est nice quod.

556
00:24:01,585 --> 00:24:03,710
Select patrocinatur suus
dicitur in vi praedicati, quod est

557
00:24:03,710 --> 00:24:06,630
quasi via simpliciter quid vis.

558
00:24:06,630 --> 00:24:10,590
Ubi pares username
quote, Unquote Malan.

559
00:24:10,590 --> 00:24:13,680
Quare hic quoque sum integer
intra argument

560
00:24:13,680 --> 00:24:16,110
ut a PHP functio, a SQL linea code.

561
00:24:16,110 --> 00:24:18,680
Et quod hoc signum SQL
tempus ad literam euntem

562
00:24:18,680 --> 00:24:21,790
ad scrutandum pro quote, Unquote Malan.

563
00:24:21,790 --> 00:24:24,420
>> Sed non omnia utilis
ita Im 'iens ut omit

564
00:24:24,420 --> 00:24:28,650
Im 'iens et dimittere
hoc a tip Brady et vade

565
00:24:28,650 --> 00:24:30,990
et plug-in pro
a hic quaestio marcam.

566
00:24:30,990 --> 00:24:33,290
Unde manifestum est, quod
si vobis carissimi secundam scribo argument

567
00:24:33,290 --> 00:24:37,480
sicut si aliquis sit initium et
vel etiam si volo sisto

568
00:24:37,480 --> 00:24:39,265
a user?

569
00:24:39,265 --> 00:24:40,140
AUDITORES: [tacita]

570
00:24:40,140 --> 00:24:40,890
DAVID Malan: Yeah.

571
00:24:40,890 --> 00:24:44,120
Audio pupa signum underscore
GET quote, Unquote username.

572
00:24:44,120 --> 00:24:50,040
Et qui reverteretur ad me
in aliquo ordine database

573
00:24:50,040 --> 00:24:51,986
quae habent username of Malan.

574
00:24:51,986 --> 00:24:54,860
Utinam nunc, Im 'iens impetro tergum
si ponatur Malan nunquam fuisses hic,

575
00:24:54,860 --> 00:24:56,290
vel, si habet.

576
00:24:56,290 --> 00:24:59,026
Ut non impetro tergum
duas vel tres vel quatuor.

577
00:24:59,026 --> 00:24:59,526
Quam ob causam?

578
00:24:59,526 --> 00:25:00,220
>> AUDITORES: [tacita]

579
00:25:00,220 --> 00:25:01,120
>> DAVID Malan: dixi unique, ius?

580
00:25:01,120 --> 00:25:01,750
Simplex ratio.

581
00:25:01,750 --> 00:25:04,030
Timui obtinuit eam
Unicum tantum secundum rationem,

582
00:25:04,030 --> 00:25:07,940
nulla potest nisi aut Malans
in hoc particulari database mensam.

583
00:25:07,940 --> 00:25:10,965
Sed ut omissis, ita vidisti
, quamvis ego servo usura GET

584
00:25:10,965 --> 00:25:14,350
et quamvis PSet6 condiendis tantum cibis adhibetur
GET, vos can certe POST.

585
00:25:14,350 --> 00:25:17,212
Et recordaberis quoniam Post alium
ars pro exhibenda notitia

586
00:25:17,212 --> 00:25:19,170
ex forma, sed
non manifestatur in domicilio.

587
00:25:19,170 --> 00:25:22,690
Suus parum certe tutior
similia Donec et passwords,

588
00:25:22,690 --> 00:25:25,210
quae PSet7 erit, in facto, involvunt.

589
00:25:25,210 --> 00:25:28,130
>> Sic faciamus quod in PHP
MyAdmin et vide quid accidit.

590
00:25:28,130 --> 00:25:30,020
Im 'iens ad MySQL tab.

591
00:25:30,020 --> 00:25:34,450
Et adverte quod per defaltam ipsius
PHP MyAdmin, sicut ad conandum id quod utile erit,

592
00:25:34,450 --> 00:25:37,050
seligat stellam ubi users.

593
00:25:37,050 --> 00:25:39,430
Bene, una semper vera est, ut
hoc habet imbecilles effective

594
00:25:39,430 --> 00:25:40,400
iustus lego omnibus.

595
00:25:40,400 --> 00:25:42,691
Ego autem paulo
magis reconditas et manually

596
00:25:42,691 --> 00:25:45,920
type de SELECT stella FROM users.

597
00:25:45,920 --> 00:25:48,294
>> Sed technice, vos can
quote nomine mensis.

598
00:25:48,294 --> 00:25:50,460
Sed rara quod habes,
quin animadverterem non sunt

599
00:25:50,460 --> 00:25:52,240
vestra normalis quotes in US keyboard.

600
00:25:52,240 --> 00:25:54,760
Hoc est quod dicitur backtick quae
plerumque in summo sinistram

601
00:25:54,760 --> 00:25:56,000
angulo keyboard.

602
00:25:56,000 --> 00:25:58,500
Sed rara youll
oportet etiam ut curare,

603
00:25:58,500 --> 00:25:59,950
sic EGO Peius 'iustus omittimus usquam.

604
00:25:59,950 --> 00:26:02,280
Nunc igitur vade et percute me praecedere.

605
00:26:02,280 --> 00:26:06,616
Quot mihi ordines
back cum lego stellam de users?

606
00:26:06,616 --> 00:26:08,407
>> AUDITORES: [tacita]

607
00:26:08,407 --> 00:26:09,990
DAVID Malan: numerus ordines tutam.

608
00:26:09,990 --> 00:26:12,390
Quot autem in hac
concrete story ius nunc?

609
00:26:12,390 --> 00:26:14,640
Duo, quia non erat
me et factum est Rob.

610
00:26:14,640 --> 00:26:19,370
Nam si click vade quoniam uideo uisum
Ive 'Acquisivi retro quidem tripertito.

611
00:26:19,370 --> 00:26:22,060
Illic 'multus of acervi super
elit, sed tantum duo ordines.

612
00:26:22,060 --> 00:26:28,580
Sed rursus si hoc faciunt
LEGO stella FROM users, ubi username

613
00:26:28,580 --> 00:26:31,840
quote pares, Unquote
Malan, nunc si ego click Vade,

614
00:26:31,840 --> 00:26:33,970
Im 'non iens impetro tergum interpretatus.

615
00:26:33,970 --> 00:26:36,499
Et demum, si facio
aliquid simile hoc, credo,

616
00:26:36,499 --> 00:26:38,290
quod non pertinet ad eum de
questus omnia,

617
00:26:38,290 --> 00:26:41,020
quoddam quod inane autem
quia tantum duas columnas.

618
00:26:41,020 --> 00:26:43,103
Suus 'non sum Scipio
a ingens amount of notitia.

619
00:26:43,103 --> 00:26:46,720
Puta me grassor quod
do SELECT nomen FROM

620
00:26:46,720 --> 00:26:51,990
users, ubi pares username Malan,
quid suus 'nice quod circa SQL honeste,

621
00:26:51,990 --> 00:26:54,290
quod est vere iustus
dic quid agere debeamus.

622
00:26:54,290 --> 00:26:57,550
Suus 'pulchellus succincta sed litteram
dic quid vis ut faciam.

623
00:26:57,550 --> 00:27:01,130
Select a nomine ubi users
litteras maiusculas pares Malan.

624
00:27:01,130 --> 00:27:03,440
Et quod sit expressa.

625
00:27:03,440 --> 00:27:08,410
Ita nunc nisi vitae euntes quot
iens impetro tergum versus sum?

626
00:27:08,410 --> 00:27:10,770
Unum, quod suus 'iustus Malan, spero.

627
00:27:10,770 --> 00:27:13,100
Aut nulla, si non
ibi, sed maxime.

628
00:27:13,100 --> 00:27:17,610
>> Quot igitur columnae reverteris

629
00:27:17,610 --> 00:27:18,450
Quot columnae?

630
00:27:18,450 --> 00:27:20,658
Et tunc Im 'iustus iens
quia non quaereremus

631
00:27:20,658 --> 00:27:22,380
lego stella quae omnia.

632
00:27:22,380 --> 00:27:27,900
Scipio nomen, sicut et ego, et ego
iustus impetro tergum uno agmine et uno ordine lignorum.

633
00:27:27,900 --> 00:27:31,730
Et spectat huiusmodi opportunioribus
ridiculum, iustus vultus eximius

634
00:27:31,730 --> 00:27:33,060
parvum hoc diligunt.

635
00:27:33,060 --> 00:27:34,290
Quid suus 'vere fit?

636
00:27:34,290 --> 00:27:36,890
Cum facere SQL
query usura selectis seligi

637
00:27:36,890 --> 00:27:38,700
quis vestri 'questus
a database

638
00:27:38,700 --> 00:27:42,970
est sicut tabula temporaria
cum ordines columnarum fortasse

639
00:27:42,970 --> 00:27:46,260
sed ut omittam quod
non tam te elegit.

640
00:27:46,260 --> 00:27:49,010
Unde si quis habuit magnum similis
spreadsheet omnium alumnorum

641
00:27:49,010 --> 00:27:51,610
descripserunt aliquot
discipulo coetus, et dicitis:

642
00:27:51,610 --> 00:27:55,097
omnia quae habes, da mihi freshman
descripserunt studiosum coetus Noster quid

643
00:27:55,097 --> 00:27:56,930
collegam in
studiosum group facerent

644
00:27:56,930 --> 00:27:58,430
is iustus tradere non potuerunt
spreadsheet te fuit universus orbis.

645
00:27:58,430 --> 00:27:59,742
Dicens quod sicut stella selectis.

646
00:27:59,742 --> 00:28:02,200
Quod suus 'aliquantulus molestiae nisi
te solum voluisse freshman.

647
00:28:02,200 --> 00:28:05,640
Itaque si loco ait
select stellam de mensa database

648
00:28:05,640 --> 00:28:08,470
ubi anno pares
quote, Unquote freshman,

649
00:28:08,470 --> 00:28:10,810
suus 'tamquam amicum vestrum
in studiosum group

650
00:28:10,810 --> 00:28:13,770
et litteram highlighted
transcribi tantum freshman ordines,

651
00:28:13,770 --> 00:28:16,780
crustulum in nova Google
Vel an Praecedo spreadsheet file,

652
00:28:16,780 --> 00:28:18,860
et tradiderunt te in
inde file tantum.

653
00:28:18,860 --> 00:28:21,710
Quod suus omnes quod suus 'iens
hic in ratione.

654
00:28:21,710 --> 00:28:23,920
>> Sic tandem possumus
somnium res aliqua pulchellus

655
00:28:23,920 --> 00:28:26,560
per omnia pro similitudine thesaurizantes usernames
et passwords et alia huiusmodi.

656
00:28:26,560 --> 00:28:30,310
Verum evenit, quod faciamus
paulo aliter quam hoc.

657
00:28:30,310 --> 00:28:34,750
Non solum illest
tani usoris in tortor.

658
00:28:34,750 --> 00:28:37,790
Quis ante puto
hic ID suggessit.

659
00:28:37,790 --> 00:28:40,787
Nunc an ID posset esse quasi
Yale vel Harvard scriptor ID ID Net,

660
00:28:40,787 --> 00:28:42,870
sed poterat etiam simplicior
in nostram database casu.

661
00:28:42,870 --> 00:28:45,120
Et quidem satis vulgatum
est habere alterius columnae.

662
00:28:45,120 --> 00:28:46,953
Et Im 'iens ire
ante et edit mensa mea ciborum reliquias.

663
00:28:46,953 --> 00:28:49,521
Et si ludere circum
hoc interface for PSet7,

664
00:28:49,521 --> 00:28:51,770
youll 'animadverto ut vos can reprehendo
hoc puga pyga hic et add

665
00:28:51,770 --> 00:28:53,750
haberet ad principium tabellae.

666
00:28:53,750 --> 00:28:56,720
Si ego click vade suus 'iens
illae ad me unus

667
00:28:56,720 --> 00:28:57,600
ex superioribus.

668
00:28:57,600 --> 00:29:00,170
Id ego addere campo.

669
00:29:00,170 --> 00:29:03,070
Im 'iens ut et numerica type.

670
00:29:03,070 --> 00:29:05,362
>> Habeo totum fasciculum
de valoribus pro Numerics.

671
00:29:05,362 --> 00:29:08,677
Im 'iustus iens ad eligendum et INT
solliciti disparatam praebebant.

672
00:29:08,677 --> 00:29:10,510
EGO dont 'have ut proprius
longitudinem vel a valorem,

673
00:29:10,510 --> 00:29:13,710
quoniam suus 'iens esse
XXXII bits nulla materia quid.

674
00:29:13,710 --> 00:29:16,070
Attributa non vidimus ante.

675
00:29:16,070 --> 00:29:18,410
Quis interest in anima ex omnibus his
menu options hoc tempus?

676
00:29:18,410 --> 00:29:21,890

677
00:29:21,890 --> 00:29:23,745
Nam INT?

678
00:29:23,745 --> 00:29:24,620
Quid vis?

679
00:29:24,620 --> 00:29:27,350

680
00:29:27,350 --> 00:29:28,445
No?

681
00:29:28,445 --> 00:29:29,570
Quicquam faciunt sensus?

682
00:29:29,570 --> 00:29:30,536
Yeah.

683
00:29:30,536 --> 00:29:31,900
Yeah, unsigned, ius?

684
00:29:31,900 --> 00:29:35,930
>> Fere simus daturus
omnis numerus a unique, quae

685
00:29:35,930 --> 00:29:38,200
Ibi haec fabula est
ire, ego vere volo solum

686
00:29:38,200 --> 00:29:41,919
homo se palmarum numerum quasi nulla
et duo et tria et quatuor.

687
00:29:41,919 --> 00:29:43,710
Ego operor non postulo ut tracto
cum numeri negative.

688
00:29:43,710 --> 00:29:45,210
Iustum indebitum videtur complexionem.

689
00:29:45,210 --> 00:29:48,470
Volo quattuor billion possibilis valores,
non quattuor billion possibilis valores,

690
00:29:48,470 --> 00:29:50,699
sic EGO iustus duplicavit
pro captu meo INT.

691
00:29:50,699 --> 00:29:53,490
Ut abiciat, etiamsi referre nolim te
hoc aliquid sicut Facebook,

692
00:29:53,490 --> 00:29:56,190
meum in die quadam
Facebook Qui prior egressus est,

693
00:29:56,190 --> 00:29:59,510
Credo quod non erant
usura MySQL in eorum database

694
00:29:59,510 --> 00:30:02,856
congregem a user scriptor
identifier, iustus erat INT.

695
00:30:02,856 --> 00:30:05,230
Sed cursus enim sit amet elit
Aliquam in mundo.

696
00:30:05,230 --> 00:30:07,438
Illic 'multus fictus Facebook
numerans in mundo.

697
00:30:07,438 --> 00:30:11,701
Et sic tandem, Facebook inundare consuevit
magnitudinem int, a quatuor sescenti

698
00:30:11,701 --> 00:30:12,200
valorem.

699
00:30:12,200 --> 00:30:15,032
Quam ob rem, si attenderis
converte manum tuam et illic 'websites

700
00:30:15,032 --> 00:30:16,740
ut indicet tibi quid
tuum est unique ID.

701
00:30:16,740 --> 00:30:19,781
Et si non in locum delegit username
Cornelius, tu videris unique ID.

702
00:30:19,781 --> 00:30:23,080
EGO reputo suus 'profile dot PHP
quaestio marcam ID pares aliquid.

703
00:30:23,080 --> 00:30:27,210
Vas quoddam velut linteum magnum quod nunc
Int aut longa diu quamuis

704
00:30:27,210 --> 00:30:29,700
LXIV frenum valor est
aut aliquid simile.

705
00:30:29,700 --> 00:30:33,620
>> Et haec quidem in natura
exitus tandem aliquando materiam.

706
00:30:33,620 --> 00:30:37,600
Quod evenit, si me
Id mei users singularem curam omnem,

707
00:30:37,600 --> 00:30:41,750
Volo eximius explicitum
minime huius agri unique.

708
00:30:41,750 --> 00:30:44,750
Sed evenit quod unum
piece of nomenclature hodiernis quoque temporibus

709
00:30:44,750 --> 00:30:46,470
quod a prima clavis.

710
00:30:46,470 --> 00:30:49,800
Si vestri 'a malitiosis database
mensamque et scitis in antecessum

711
00:30:49,800 --> 00:30:55,580
quod in mensa columnarum
ut et unice identify ordines

712
00:30:55,580 --> 00:30:58,500
mensa vis
exprimeret nuntians datorum

713
00:30:58,500 --> 00:31:00,250
hoc est primarium key.

714
00:31:00,250 --> 00:31:02,110
Esse poterat duplicates
in alios agros,

715
00:31:02,110 --> 00:31:06,330
sed hoc quod ego loquor in database
est esse primarium, mea maxima agri,

716
00:31:06,330 --> 00:31:08,420
quod suus certo erit singulare.

717
00:31:08,420 --> 00:31:09,660
>> Sed hoc videtur inconveniens.

718
00:31:09,660 --> 00:31:13,830
Ego nunc rogari ut
adde, per clicking hic Save,

719
00:31:13,830 --> 00:31:17,210
cum haberet agrum vocationis vestrae et Im 'iens
praecedere click AI

720
00:31:17,210 --> 00:31:19,720
revertemur ad
quod in praesenti est momentaneum et salva.

721
00:31:19,720 --> 00:31:22,540
Ego sum nunc quod proponendo
mensa mea ciborum reliquias vultus amo is.

722
00:31:22,540 --> 00:31:26,305
Habeo INT campo vocato an ID,
a CHAR campo vocato utetur nomen,

723
00:31:26,305 --> 00:31:31,100
a VARCHAR campo vocato nomine, sed ID,
Si suus 'primaria ideoque ex se unico,

724
00:31:31,100 --> 00:31:33,760
cur ego iustus tererent
quod tempus introducendis

725
00:31:33,760 --> 00:31:39,140
efficacius est secunda unique
ID agro dicitur quod suus 'an INT?

726
00:31:39,140 --> 00:31:41,980
>> Username, receptui fuit
iam unicum, superius diximus.

727
00:31:41,980 --> 00:31:45,350
Quomodo ergo secundum rationem, non opus
quis database experientia rationem

728
00:31:45,350 --> 00:31:47,570
per hoc, quod
possem introduxerint

729
00:31:47,570 --> 00:31:50,065
mihi tam singulari identifier int?

730
00:31:50,065 --> 00:31:52,740

731
00:31:52,740 --> 00:31:53,930
Quid Teraho iterum dico?

732
00:31:53,930 --> 00:31:55,580
>> AUDITORES: [tacita]

733
00:31:55,580 --> 00:31:59,534
>> DAVID Malan: Random
aditum est facilius, quid?

734
00:31:59,534 --> 00:32:00,410
>> AUDITORES: [tacita]

735
00:32:00,410 --> 00:32:02,367
DAVID Malan: Yeah, suus '
just accessu numeri.

736
00:32:02,367 --> 00:32:04,750
Si uero de hoc
mensa velut aciem

737
00:32:04,750 --> 00:32:07,690
nunc habeo unique identifiers
quia non possum jump per circuitum.

738
00:32:07,690 --> 00:32:11,520
Et tamen melius est
quantus futurus est INT iterum

739
00:32:11,520 --> 00:32:14,450

740
00:32:14,450 --> 00:32:15,800
XXXII bits pagellas vel quattuor scidit bytes.

741
00:32:15,800 --> 00:32:17,750
>> Quantus usoris mihi futurum est?

742
00:32:17,750 --> 00:32:20,310

743
00:32:20,310 --> 00:32:21,990
Maxime?

744
00:32:21,990 --> 00:32:22,880
XVI bytes.

745
00:32:22,880 --> 00:32:26,080
>> Quare si vere curantes
perficientur vestra code,

746
00:32:26,080 --> 00:32:31,390
ad cogitandum PSet5, utrumne
quaerere a quatuor aut a value byte XVI

747
00:32:31,390 --> 00:32:32,240
byte valorem, ius?

748
00:32:32,240 --> 00:32:33,810
Tamen est simplex.

749
00:32:33,810 --> 00:32:38,060
Ut facias quadruplum operis
ad scrutandum pro usernames quia illi

750
00:32:38,060 --> 00:32:38,830
sunt XVI bytes.

751
00:32:38,830 --> 00:32:41,320
Sic, vos have ut litteram
compararunt omnia XVI bytes esse

752
00:32:41,320 --> 00:32:43,140
Certe quia haec usoris volo.

753
00:32:43,140 --> 00:32:46,610
Cum enim INT potes
faciunt quatuor bytes justo.

754
00:32:46,610 --> 00:32:49,212
>> Et quasi seorsum illis
interested in computer hardware,

755
00:32:49,212 --> 00:32:52,420
fit aliquid evenit possis
an INT vel a XXXII frenum in aliquid value

756
00:32:52,420 --> 00:32:55,330
dicitur register in a computer
CPU, quod interpretatur suus 'super,

757
00:32:55,330 --> 00:32:58,400
luctus et ultimus
aequum est eu odio.

758
00:32:58,400 --> 00:33:00,530
Itaque non justo commodo undique.

759
00:33:00,530 --> 00:33:01,530
Quid est hoc?

760
00:33:01,530 --> 00:33:04,850
Nam cum sis malitiosis
database mensae pene temporis

761
00:33:04,850 --> 00:33:07,170
facturi estis habere non
niam data solum,

762
00:33:07,170 --> 00:33:09,280
sed etiam aliquid simile
a unique Identifier

763
00:33:09,280 --> 00:33:11,280
quia hoc est iens ut
operemur alia.

764
00:33:11,280 --> 00:33:13,160
Et quis est dubium scandali.

765
00:33:13,160 --> 00:33:15,990
>> Item esto quod users non habent
Donec et sicut nomina,

766
00:33:15,990 --> 00:33:19,540
sed etiam urbes huiusmodi
tates et zip codes, saltem

767
00:33:19,540 --> 00:33:20,432
Hic in US.

768
00:33:20,432 --> 00:33:22,390
Ita Im 'iens ut antecedat
et iustus cito dicam,

769
00:33:22,390 --> 00:33:26,180
da mihi tres columnas
in fine tabulae.

770
00:33:26,180 --> 00:33:28,900
Quod fore urbis
hic status est futurus,

771
00:33:28,900 --> 00:33:30,400
Nulla id fore.

772
00:33:30,400 --> 00:33:32,710
>> Iam urbe, quod notitia typus
hic fortasse?

773
00:33:32,710 --> 00:33:35,460

774
00:33:35,460 --> 00:33:35,989
VARCHAR?

775
00:33:35,989 --> 00:33:37,780
Nescio quid sit
longissima nomen urbi impositum est.

776
00:33:37,780 --> 00:33:40,571
Alicubi in America, illic '
probabiliter quidam ridicule diu verbum,

777
00:33:40,571 --> 00:33:43,605
sic lets iustus CCLV cum aliquanto
historice seu quod ex arbitrio.

778
00:33:43,605 --> 00:33:44,730
Rem publicam, quid vis?

779
00:33:44,730 --> 00:33:48,380

780
00:33:48,380 --> 00:33:50,367
Iudicium vocatus est, aequum?

781
00:33:50,367 --> 00:33:51,700
Quid maybe Aequicum uel acerrimus fuit?

782
00:33:51,700 --> 00:33:53,500
Quot ingenia?

783
00:33:53,500 --> 00:33:55,950
Aliquam justo duo si possumus
impune iustus faciendo,

784
00:33:55,950 --> 00:33:58,250
huiusmodi enim Rhode MA salutem.

785
00:33:58,250 --> 00:34:00,520
Ita, partes eae fuerunt duae chari ibo.

786
00:34:00,520 --> 00:34:03,080
>> Cras amet qui Codicis.

787
00:34:03,080 --> 00:34:06,679
Nos hic in MMCXXXVIII, ut
suggerit debemus uti quid?

788
00:34:06,679 --> 00:34:07,470
Suus 'INT iudicium

789
00:34:07,470 --> 00:34:10,030

790
00:34:10,030 --> 00:34:12,800
INT, INT, brevi?

791
00:34:12,800 --> 00:34:14,521
Breve operari.

792
00:34:14,521 --> 00:34:15,020
No?

793
00:34:15,020 --> 00:34:18,920

794
00:34:18,920 --> 00:34:20,870
CHAR vel quinque, sed volo an INT.

795
00:34:20,870 --> 00:34:23,710
Quid repellendum in INT?

796
00:34:23,710 --> 00:34:26,820
Persuadere mihi potuit ex eo.

797
00:34:26,820 --> 00:34:29,210
Quid stultus fere INT mea idea?

798
00:34:29,210 --> 00:34:29,871
Yeah.

799
00:34:29,871 --> 00:34:31,199
>> AUDIENCE tollite recordabor amplius.

800
00:34:31,199 --> 00:34:32,909
>> DAVID Malan: Tolle grabatum recordabor amplius.

801
00:34:32,909 --> 00:34:35,310
Quattuor bytes, sed tu
proponenti zip code

802
00:34:35,310 --> 00:34:39,000
sicut quinque bytes aut quasi CHAR,
eh quod sentit, quod non

803
00:34:39,000 --> 00:34:39,620
causam.

804
00:34:39,620 --> 00:34:40,489
>> Bene, fun fabulam.

805
00:34:40,489 --> 00:34:43,179
Annos, cum utebantur
Microsoft Outlook mea email,

806
00:34:43,179 --> 00:34:45,150
Tandem voluerunt switch ad Gmail.

807
00:34:45,150 --> 00:34:48,949
Itaque, omnibus e meis exportari
sicut de consuetudine Outlook CSV lima.

808
00:34:48,949 --> 00:34:50,699
Comma separata valores,
qua mox intelligitur I

809
00:34:50,699 --> 00:34:54,060
novissime autem omnium amicorum nominibus
phone numerus et nomina et zip codes

810
00:34:54,060 --> 00:34:54,747
omnique cognatione illa.

811
00:34:54,747 --> 00:34:56,580
Et ego feci
errorem aperiendi illud

812
00:34:56,580 --> 00:34:58,640
in Excel, quae a
spreadsheet progressio ut

813
00:34:58,640 --> 00:35:00,289
intelligit CSV files ut weve videri.

814
00:35:00,289 --> 00:35:03,080
Tum ego ledo simile
Ante imperium deinde Imperium S ad unum punctum.

815
00:35:03,080 --> 00:35:06,250
Et apparenter Excel tempore
habebat pluma qua aliquo tempore

816
00:35:06,250 --> 00:35:08,100
vidit numerum conata est utile.

817
00:35:08,100 --> 00:35:11,610
Et si ille numerus coepi
cyphris tollendum esset iustus exercitus.

818
00:35:11,610 --> 00:35:13,420
Quare necesse ducens
zeros on integros?

819
00:35:13,420 --> 00:35:15,140
Haerent vanitas mathematice.

820
00:35:15,140 --> 00:35:17,530
Haerent non vanitas
in US Praesent ratio.

821
00:35:17,530 --> 00:35:19,954
Sic ego iam annis
usque in praesentem diem adhuc

822
00:35:19,954 --> 00:35:22,370
amicos cum
quod rarum est Egeo

823
00:35:22,370 --> 00:35:24,078
alloqui implerentur dies convivii,
Ego tamen videte, quoniam ego

824
00:35:24,078 --> 00:35:26,767
habebit amicum in Cambridge,
Massachusetts, MMCXXXVIII.

825
00:35:26,767 --> 00:35:29,350
Et si tu eam molesta
conatur sort of programmatically

826
00:35:29,350 --> 00:35:30,975
generare opercula vel iustus iota eam.

827
00:35:30,975 --> 00:35:33,599
Et hoc ideo est,
Elegi iniuriam notitia typus.

828
00:35:33,599 --> 00:35:34,490
Ergo idea tua dilexi.

829
00:35:34,490 --> 00:35:35,650
Lets uti chari agro.

830
00:35:35,650 --> 00:35:38,340
Quinque characters, nisi
est angulo casu.

831
00:35:38,340 --> 00:35:42,220
Si tamen mittere,
quandoque zip codes implerentur dies convivii,

832
00:35:42,220 --> 00:35:45,360
haerent, ut, plus quatuor.

833
00:35:45,360 --> 00:35:48,200
Sic et opus hyphen
nos postulo quattuor numerorum.

834
00:35:48,200 --> 00:35:50,330
Ut sit amet, posset
go multis diversisque itineribus iretur.

835
00:35:50,330 --> 00:35:52,371
>> Nunc, Im 'iens ut custodiant
simplex et Im 'iustus

836
00:35:52,371 --> 00:35:54,780
dicturi suus
quinque CHAR valorem et sumus

837
00:35:54,780 --> 00:35:56,739
iens ut skip totum offendas plus quattuor.

838
00:35:56,739 --> 00:35:58,280
Huiusmodi autem sunt genera tradeoffs.

839
00:35:58,280 --> 00:36:00,196
Et vos potest cogitare de
eadem problemata, quae

840
00:36:00,196 --> 00:36:01,860
phone cum aliis numeris.

841
00:36:01,860 --> 00:36:04,350
>> Et nunc hoc est actu
Via stulti descendere.

842
00:36:04,350 --> 00:36:08,000
Supponere tam Rob et ego et Anna
et Maria et [? Davon?] Et Andy

843
00:36:08,000 --> 00:36:12,820
Vivamus baculo et aliis
in Cambridge, MA, MMCXXXVIII.

844
00:36:12,820 --> 00:36:17,970
Is vere stultus sum, qui
additis users mensam meam Civitatis statum

845
00:36:17,970 --> 00:36:18,630
et zip.

846
00:36:18,630 --> 00:36:20,980
Quam ob causam?

847
00:36:20,980 --> 00:36:21,960
>> AUDITORES: [tacita]

848
00:36:21,960 --> 00:36:22,918
>> DAVID Malan: Dic iterum?

849
00:36:22,918 --> 00:36:24,310
AUDITORES: [tacita]

850
00:36:24,310 --> 00:36:25,850
>> DAVID Malan: Haerent semper
simul ad iudicium

851
00:36:25,850 --> 00:36:28,660
Quo evenit, ut putabam
Quae cum ita essent, donec quadam

852
00:36:28,660 --> 00:36:30,570
scrutantique omne US,
et evenit quod ibi

853
00:36:30,570 --> 00:36:32,653
Sunt quidam repugnantis
ubi multa oppida habere

854
00:36:32,653 --> 00:36:35,060
idem zip, quae est fatum.

855
00:36:35,060 --> 00:36:40,580
Si autem ponamus quod nunc MMCXXXVIII
semper Cambridge, MA,

856
00:36:40,580 --> 00:36:44,910
quid tibi thesaurizas in mundo
vestri database Cambridge et MA et MMCXXXVIII

857
00:36:44,910 --> 00:36:49,357
Anna et mihi et Rob
pro [? Davon?] Et pro aliis qui vivere

858
00:36:49,357 --> 00:36:51,190
hic in Cambridge, suus '
perfecte redundant.

859
00:36:51,190 --> 00:36:54,480
>> Debemus abite
cum iustus thesaurizantes quid?

860
00:36:54,480 --> 00:36:55,610
Iustus zip code.

861
00:36:55,610 --> 00:36:58,660
Sed si tantum condimus
Numeri codice, velim fortasse,

862
00:36:58,660 --> 00:37:02,160
nam scire MMCXXXVIII website est.

863
00:37:02,160 --> 00:37:03,910
Itaque nullius alterius tabulae.

864
00:37:03,910 --> 00:37:04,697
Et quod suus 'OK.

865
00:37:04,697 --> 00:37:07,530
Denique hoc est
consilium processus cogitans tabulas

866
00:37:07,530 --> 00:37:11,472
ut faciam in PSet7 tam per
vis factor de communi data.

867
00:37:11,472 --> 00:37:14,430
Iustus amo nos Ive 'been factoring ex
commune signum et factoring ex communi

868
00:37:14,430 --> 00:37:17,380
styles de CSS, here
etiam in database,

869
00:37:17,380 --> 00:37:21,180
si tantum postulo ad MMCXXXVIII unice
identify alicuius patria,

870
00:37:21,180 --> 00:37:25,020
non reponant Londini pro
darn omni user in mensa tua occurrerunt.

871
00:37:25,020 --> 00:37:29,770
>> Sed habent esse distinctum dicitur table
Zips quod habeat columnae?

872
00:37:29,770 --> 00:37:33,490
Probabiliter ID agri, propter quod
principiis loquimur nunc.

873
00:37:33,490 --> 00:37:35,720
Probably a zip agrum MMCXXXVIII.

874
00:37:35,720 --> 00:37:38,400
Et fortasse alia columnis;

875
00:37:38,400 --> 00:37:42,950
Urbis statum, sed solum unum
ordo enim MMCXXXVIII, uno ordine lignorum pro MMCXXXIX,

876
00:37:42,950 --> 00:37:44,772
uno ordine lignorum pro (XC)CCX.

877
00:37:44,772 --> 00:37:46,730
Et hoc est ad litteram
Scio omnes zip codes.

878
00:37:46,730 --> 00:37:49,012
>> Nunc ergo quid facies?

879
00:37:49,012 --> 00:37:51,220
Hoc est inconveniens, quia
iam habeo duas tabulas.

880
00:37:51,220 --> 00:37:54,660
Nam mihi users plerumque huc
sed urbem etiam status notitia suus

881
00:37:54,660 --> 00:37:55,390
huc.

882
00:37:55,390 --> 00:37:58,635
Ita fit cum SQL, nihil
ita etiam ad indicium

883
00:37:58,635 --> 00:38:00,470
et videbis posteriora in hoc pset.

884
00:38:00,470 --> 00:38:03,000
>> Sed evenit potes
faciat quippiam huius rei simile.

885
00:38:03,000 --> 00:38:10,501
LEGO stella FROM users, JOIN zips ON
users dot dot zip pares zips zip.

886
00:38:10,501 --> 00:38:13,360
Quod est paulo ad uerborum linguaeque,
fateri oportet, sed hoc iusto

887
00:38:13,360 --> 00:38:17,590
: quod significet omnia quae ex selectis
processus of accipiens users mensam meam

888
00:38:17,590 --> 00:38:19,580
et zips mensam meam.

889
00:38:19,580 --> 00:38:22,120
Conjunge illa in unum
agros habent in agmen.

890
00:38:22,120 --> 00:38:24,780
Ita, ad litteram aliquid
talia et redde

891
00:38:24,780 --> 00:38:27,360
novum temporaria table
quod latius patet, quod maior,

892
00:38:27,360 --> 00:38:29,450
qui habet omnia quae de
columnae ab utroque illorum.

893
00:38:29,450 --> 00:38:33,510
Et hoc simpliciter esset
faciendo tale syntax.

894
00:38:33,510 --> 00:38:35,540
>> Itaque non hoc ante
sed suus 'iens

895
00:38:35,540 --> 00:38:38,950
aliud esse consilium decisiones youll
etiam, ut non so- lum index

896
00:38:38,950 --> 00:38:40,550
sed etiam currit in elit.

897
00:38:40,550 --> 00:38:43,360
Nam nulla provocatione
in quis consilium database

898
00:38:43,360 --> 00:38:47,930
quibus aliquando duo vires volo
ut obvius idem ordinibus database

899
00:38:47,930 --> 00:38:48,530
mensa.

900
00:38:48,530 --> 00:38:51,450
Et hoc est quod tibi placet
perspiciatis in PSet7 pariter.

901
00:38:51,450 --> 00:38:54,686
>> Vellem autem existimavi aspicitis
impetum in SQL quod possibile.

902
00:38:54,686 --> 00:38:56,560
Quid sunt quidam de
problems quod possit oriri?

903
00:38:56,560 --> 00:38:58,170
Sic, youll perspiciatis hoc in PSet7.

904
00:38:58,170 --> 00:39:01,874
Et quid dicam ornes
coding hoc problema est.

905
00:39:01,874 --> 00:39:04,790
Quod si altius genus
Praesertim in operating ratio,

906
00:39:04,790 --> 00:39:06,950
vos erant 'iens ut perspiciatis
fluxum patiebatur atomicity,

907
00:39:06,950 --> 00:39:10,080
quaestionem facere conatur
plura autem simul universa turba

908
00:39:10,080 --> 00:39:11,000
sine intermissione.

909
00:39:11,000 --> 00:39:14,560
>> Et dixi ego hunc
idea enim PSet7 cum metaphora

910
00:39:14,560 --> 00:39:18,160
quam sine fictione didici, quod me in Margo
Seltzer CS164 scriptor operating ratio

911
00:39:18,160 --> 00:39:18,990
class annis ago.

912
00:39:18,990 --> 00:39:22,230
Puta te harum dorm
fridges in Dorm locus vel domo erectis,

913
00:39:22,230 --> 00:39:24,474
nullam rem lactis ridere.

914
00:39:24,474 --> 00:39:27,140
Et ita quando revertatur a classes
die aperire amet.

915
00:39:27,140 --> 00:39:27,620
Oh, perduint it.

916
00:39:27,620 --> 00:39:28,870
Lac amet nulla.

917
00:39:28,870 --> 00:39:32,470
Sic claudis amet,
claude ostium, clauditis tua Dorm,

918
00:39:32,470 --> 00:39:34,770
obambulare anguli
CVS est, ut in acie

919
00:39:34,770 --> 00:39:36,312
et committitur reprehendo sicco pro lac.

920
00:39:36,312 --> 00:39:38,978
Quod suus 'iens ut dum
quia illa damnant sui Solvo

921
00:39:38,978 --> 00:39:40,570
calculis accipere uti usquam in aeternum.

922
00:39:40,570 --> 00:39:41,950
Sic interim vestra roommate veniens domum.

923
00:39:41,950 --> 00:39:43,470
Ipse velit esse quam lactis.

924
00:39:43,470 --> 00:39:45,520
Veniunt in Dorm locus,
Aperiam amet o darn it.

925
00:39:45,520 --> 00:39:46,490
Illic 'haud plus quam lactis abundans.

926
00:39:46,490 --> 00:39:49,040
>> Sic, et ipsa
universa circuitu pergit spiritus est in caput anguli.

927
00:39:49,040 --> 00:39:51,670
Nunc vero ibi duobus
aut ternis aut quaternis CVSes prope

928
00:39:51,670 --> 00:39:53,800
forte ad unum
diversis in quadratum.

929
00:39:53,800 --> 00:39:55,830
Nunc itaque paulisper
postea ambo

930
00:39:55,830 --> 00:39:58,060
adveniens offendi domi ugh et incommoda, pessimi forsit aeternum.

931
00:39:58,060 --> 00:40:00,967
Sed scis nimium lac
quoniam suus 'iens ut uvam.

932
00:40:00,967 --> 00:40:03,050
Et lac, sed
non vere amo quam lactis abundans.

933
00:40:03,050 --> 00:40:06,730
>> Nunc sumptuosum erat
modo errare, quod uterque vestrum

934
00:40:06,730 --> 00:40:09,870
fecit decisionem substructio in
status quidam variabilis illius

935
00:40:09,870 --> 00:40:12,660
fuit in processu
moveatur a te,

936
00:40:12,660 --> 00:40:14,560
initiator profitenda lac.

937
00:40:14,560 --> 00:40:17,785
Quae forte hominem
problematis solutio ad illud?

938
00:40:17,785 --> 00:40:18,660
AUDITORES: [tacita]

939
00:40:18,660 --> 00:40:19,430
DAVID Malan: Leave a note, ius?

940
00:40:19,430 --> 00:40:21,850
Semper relinquat note si tu
nota quod show.

941
00:40:21,850 --> 00:40:23,100
Nam duo sunt ex nobis.

942
00:40:23,100 --> 00:40:25,940
Proinde relinquere nota, vel
ad litteram clauditis refrigerator

943
00:40:25,940 --> 00:40:28,602
habet aliquam speciem vel padlock
capite aliquid huiusmodi.

944
00:40:28,602 --> 00:40:31,310
Duis sed etiam futuri
key quaestio database consilium,

945
00:40:31,310 --> 00:40:34,710
praesertim cum habeamus
multiple navigatores, multiple laptops,

946
00:40:34,710 --> 00:40:37,450
multiple users omnes autem hii
update notitia simul.

947
00:40:37,450 --> 00:40:40,590
Maxime sensitiva notitia
sicut financial notitia,

948
00:40:40,590 --> 00:40:43,350
quare a stirpe negotiatione
eris quasi website aedificant

949
00:40:43,350 --> 00:40:47,270
Quod si quam pecuniam ad reprimendam
si ergo habes plurima

950
00:40:47,270 --> 00:40:48,490
emite genere soleas gloriari?

951
00:40:48,490 --> 00:40:50,899
>> Sed quid si alius qui
habet a communi nomine vobiscum

952
00:40:50,899 --> 00:40:52,690
simul conatur
emere genere soleas gloriari?

953
00:40:52,690 --> 00:40:55,190
Itaque ipse est aduersus
propter statera, utrumque vestrum

954
00:40:55,190 --> 00:40:57,540
impetro tergum eadem
Respondeo, non lac.

955
00:40:57,540 --> 00:41:00,580
An utrumque recipis responsum
rationem habetis in C $.

956
00:41:00,580 --> 00:41:04,680
Uterque conantur arbitrium
una cum emere aliquam elit.

957
00:41:04,680 --> 00:41:06,130
>> Nunc igitur si quid accidit?

958
00:41:06,130 --> 00:41:07,140
Habes duas partes?

959
00:41:07,140 --> 00:41:08,420
Vobis autem non est participat?

960
00:41:08,420 --> 00:41:10,320
Problems ut oriri potest.

961
00:41:10,320 --> 00:41:11,755
Sic, puteus 'ut perspiciatis.

962
00:41:11,755 --> 00:41:14,630
SQL iniectio impetus, gratanter
sunt aliquid quod puteus 'succurro vos cum,

963
00:41:14,630 --> 00:41:17,430
sed hi gradus sunt atrociter
communia illa his diebus adhuc.

964
00:41:17,430 --> 00:41:18,680
Et hoc est exemplum.

965
00:41:18,680 --> 00:41:21,290
Ego nihil praesumo quod
Harvard pin system est

966
00:41:21,290 --> 00:41:23,130
vulnerabiles haec particularis impugnatio.

967
00:41:23,130 --> 00:41:24,160
Weve conatus.

968
00:41:24,160 --> 00:41:26,120
Sed nosti quod ignoremus?
habere agrum hoc diligunt.

969
00:41:26,120 --> 00:41:29,620
Et Yale scriptor ID Net simile
intuens screen dies istos.

970
00:41:29,620 --> 00:41:33,190
Et si contigerit quod forte
ACUS ratio est implemented in PHP.

971
00:41:33,190 --> 00:41:37,050
>> Et si suus 'were-- not-- illi
ut signum, quod spectat sicut est hodie.

972
00:41:37,050 --> 00:41:38,210
Habent binarum variabilium.

973
00:41:38,210 --> 00:41:42,495
Da mihi username et password
post a eximius global variabilis

974
00:41:42,495 --> 00:41:43,970
quae mentio supra.

975
00:41:43,970 --> 00:41:47,310
Maybe Harvard habet query
sicut stella SELECT FROM users

976
00:41:47,310 --> 00:41:50,005
ubi username aequat illum,
et quod signum pares.

977
00:41:50,005 --> 00:41:51,880
Et nota, quod Im 'iustus
plugging in utendo

978
00:41:51,880 --> 00:41:55,050
in crispus ue notatio ex altera
die, id est iustus plug in valorem

979
00:41:55,050 --> 00:41:55,550
here.

980
00:41:55,550 --> 00:41:57,449
Im 'non usura
quaestio marcam ars.

981
00:41:57,449 --> 00:41:59,240
Ego non habent ullam secundo
seu tertium argumenta.

982
00:41:59,240 --> 00:42:02,350
Im 'iustus litteram
construendo string me.

983
00:42:02,350 --> 00:42:04,930
>> Quaestio tamen est
sicut si aliquis a scroob,

984
00:42:04,930 --> 00:42:09,020
quod respicit ad velum,
taleae in aliquo huiusmodi,

985
00:42:09,020 --> 00:42:11,250
et abstuli punctis
ut solet operire

986
00:42:11,250 --> 00:42:14,370
passwords, quod si est
praesertim malignis

987
00:42:14,370 --> 00:42:18,860
et maybe is password (XII)CCCXLV,
per movie dicitur "Spaceballs"

988
00:42:18,860 --> 00:42:21,970
sed genera a critico
una quote post quinquennium,

989
00:42:21,970 --> 00:42:24,790
tunc ad litteram verbum vel
spatio, et auctoritate,

990
00:42:24,790 --> 00:42:29,160
Unquote quote unum sunt unum,
sed percipiunt hes 'omitted quid?

991
00:42:29,160 --> 00:42:32,700
Ipse suus omissa quote a dextris
et ipse omissa quote sinistris.

992
00:42:32,700 --> 00:42:35,170
>> Quia si hoc in impugnantem insurgit
scroob praesumptionem

993
00:42:35,170 --> 00:42:38,160
quod fugisset populus inmutatumque est qui scripsit
hoc PHP codice non tam clara,

994
00:42:38,160 --> 00:42:42,990
forsitan iustus have nonnullus uno
quotes circum interpolationem

995
00:42:42,990 --> 00:42:45,210
quantitatis variabilis in crispus adstringit?

996
00:42:45,210 --> 00:42:48,620
Et sic fortasse potuit genus
of finierint cogitatio

997
00:42:48,620 --> 00:42:53,290
illis, sed quod suus 'iens modo
ut eum in pin laceratus ratio.

998
00:42:53,290 --> 00:42:55,310
In aliis verbis, si
quod hoc sit signum

999
00:42:55,310 --> 00:42:57,140
et nunc quid plug in scroob typed.

1000
00:42:57,140 --> 00:42:58,770
Quod suus red quia mala.

1001
00:42:58,770 --> 00:43:01,310
>> Et subjectam text
est quod typed in,

1002
00:43:01,310 --> 00:43:05,510
scroob posset fallere Harvard scriptor server
in exstruendis a SQL query

1003
00:43:05,510 --> 00:43:07,440
string quod spectat sicut est hodie.

1004
00:43:07,440 --> 00:43:11,760
Password (XII)CCCXLV pares pares unum aut unus apex.

1005
00:43:11,760 --> 00:43:14,820
Ex quo sequitur,
est quia hoc log scroob

1006
00:43:14,820 --> 00:43:18,360
si in his password est
(XII)CCCXLV Aut si pares

1007
00:43:18,360 --> 00:43:22,660
qui utique semper est verus,
quod est interpretatum scroob semper gets in.

1008
00:43:22,660 --> 00:43:26,060
>> Itaque quemadmodum reficere
hoc multum in causis

1009
00:43:26,060 --> 00:43:28,140
foret scribere pluris aut defensione.

1010
00:43:28,140 --> 00:43:30,390
Uti aliqua re nascitur, similis nostro
actu query functio, quae

1011
00:43:30,390 --> 00:43:33,980
youll 'animadverto in PSet7, ubi demorati sumus plug in
aliquid simile hic quaestio marcas.

1012
00:43:33,980 --> 00:43:35,980
Et speciositas
query functio, ut habemus

1013
00:43:35,980 --> 00:43:40,010
Contra quas dederit tibi eam defendit
sic-accersitus SQL iniectio impetus, ubi

1014
00:43:40,010 --> 00:43:44,260
quis putet in vestri codice
injiciunt sua cuiusque SQL code.

1015
00:43:44,260 --> 00:43:47,380
Quia quod query functio
Damus autem actu,

1016
00:43:47,380 --> 00:43:51,270
si uti quaestio marcam syntax
alterumque et tertium argumentum hic

1017
00:43:51,270 --> 00:43:54,590
addetis ad verbum quod factum est
quod si user input?

1018
00:43:54,590 --> 00:43:56,060
Qui backslash quotes.

1019
00:43:56,060 --> 00:43:58,590
>> Ut adeo fallit veritam aliqua potentia
periculosum characters.

1020
00:43:58,590 --> 00:44:01,000
Ridiculum hoc spectat nunc,
tamen suus 'non vulnerari

1021
00:44:01,000 --> 00:44:03,260
quia non
mutare logic anymore

1022
00:44:03,260 --> 00:44:06,470
quia password est totum
nunc uno quote quod non,

1023
00:44:06,470 --> 00:44:07,596
in facto, scroob scriptor password.

1024
00:44:07,596 --> 00:44:09,845
Ita illic 'aliqua iocorum
de hoc super annos.

1025
00:44:09,845 --> 00:44:12,570
Et hoc photo capta fuit
quorundam cursum in raedam sors

1026
00:44:12,570 --> 00:44:16,620
unde sciret ciuitatibus
et status conantur scan vestra licentia

1027
00:44:16,620 --> 00:44:19,460
laminam occiderit vos tessera vel ad vos
si non per similitudinem,

1028
00:44:19,460 --> 00:44:20,660
Transite ad E-Z aliquid.

1029
00:44:20,660 --> 00:44:24,490
Hec itaque homo praesumpsit atque illud vinculum maybe
populi scribens E-Z Transite system

1030
00:44:24,490 --> 00:44:28,240
minus clara et forte
just concatenated simul si rumpat quis filum,

1031
00:44:28,240 --> 00:44:32,190
ut ille vel ilia potuit non malitiose
non iustus viam suam cogitationem,

1032
00:44:32,190 --> 00:44:35,150
sed etiam facere malum praeceptum,
quod weve 'Non tamen

1033
00:44:35,150 --> 00:44:36,380
sed vos potest probabiliter suspicari.

1034
00:44:36,380 --> 00:44:39,820
Quod in addition ad delete et
interserunt update quod lego,

1035
00:44:39,820 --> 00:44:43,370
illic 'quoque a keyword dicitur gutta,
quae omnia delet litteram

1036
00:44:43,370 --> 00:44:45,300
in database, quod
praesertim est mali.

1037
00:44:45,300 --> 00:44:48,760
>> Si possumus zoom in
paulo lenta est videre.

1038
00:44:48,760 --> 00:44:52,300
Inde nunc est nobilis viverra
ut 'mire callidus nunc

1039
00:44:52,300 --> 00:44:53,145
et facile intellegitur.

1040
00:44:53,145 --> 00:45:00,880

1041
00:45:00,880 --> 00:45:04,750
>> [LAUGHTER]

1042
00:45:04,750 --> 00:45:05,910
>> Yeah, frigus.

1043
00:45:05,910 --> 00:45:06,800
Genus Geeking out.

1044
00:45:06,800 --> 00:45:08,800
Ita et isti nunc sunt
SQL iniectio sit impugnationibus defensa.

1045
00:45:08,800 --> 00:45:13,050
Et tam facile vitare utendo
ius aut ad dexteram libraries.

1046
00:45:13,050 --> 00:45:15,947
Et videbis in PSet7, quod
cur damus vobis query functio.

1047
00:45:15,947 --> 00:45:17,780
Sic a iugo of teasers
quod in nobis extinctam credebamus lubentius sumus

1048
00:45:17,780 --> 00:45:19,930
dabo tibi hic sunt in nostro
simul reliquis minutes.

1049
00:45:19,930 --> 00:45:24,030
Sicut ergo de septimana nulla memores sumus
introducitur haec duo quae lux bulbi

1050
00:45:24,030 --> 00:45:26,610
sunt nice, non solum quia
haerent lautaque fugatur,

1051
00:45:26,610 --> 00:45:29,450
sed quia aliquid sustineant:
dicitur API, an Application

1052
00:45:29,450 --> 00:45:31,980
Et programming Interface
in CS50 hucusque habuimus

1053
00:45:31,980 --> 00:45:34,440
plerumque focused et GET
POST, tamen evenit

1054
00:45:34,440 --> 00:45:37,390
illic 'alia HTTP similis QUAERO verbs.

1055
00:45:37,390 --> 00:45:39,430
>> Et in facto, hoc est
a dictum a week ciphra

1056
00:45:39,430 --> 00:45:44,930
Quare si codicem scribere mittit
a la PSet6 HTTP an item petentibus remissum

1057
00:45:44,930 --> 00:45:49,647
Huic simile est illud FRUSTUM
imo, quod vocatur JSON,

1058
00:45:49,647 --> 00:45:52,230
aut JavaScript Object Notation
ut loquar ad proxima septimana

1059
00:45:52,230 --> 00:45:57,030
potes vel arceatur elisis aut inmutatis
aspectus eorum quasi lampades.

1060
00:45:57,030 --> 00:46:00,480
Si praeter alia quoque CS50
eorum hic in lucem bulbi New Haven

1061
00:46:00,480 --> 00:46:02,480
Si youd 'amo ad fenus accipies
nam finalis projects eos,

1062
00:46:02,480 --> 00:46:04,370
atque inibi verba quaedam Microsoft
Vincula, quae sunt sicut

1063
00:46:04,370 --> 00:46:07,619
observat quod geris inter vestros oculos conlocate
quod similiter habent API ut facias

1064
00:46:07,619 --> 00:46:10,040
software pro tuo scribere.

1065
00:46:10,040 --> 00:46:12,490
>> Habemus rationem cum
Apple scriptor codice iOS ita

1066
00:46:12,490 --> 00:46:15,510
ut si quid vel vigilate Apple
iPhone vel leo vel iPod

1067
00:46:15,510 --> 00:46:17,707
vos potest scribere codicem
actu currit illis.

1068
00:46:17,707 --> 00:46:19,540
Habemus totum fasciculum
of Arduinos, quae sunt

1069
00:46:19,540 --> 00:46:22,010
minutula computers
sine casibus, essentialiter,

1070
00:46:22,010 --> 00:46:25,240
ut via vos can iungo USB
saepe tuo Mac PC,

1071
00:46:25,240 --> 00:46:28,810
scripsi percurrens codice iam corporeas
cogitationes quae saepe habent sensoriis super eos

1072
00:46:28,810 --> 00:46:30,790
possis penitus rerum.

1073
00:46:30,790 --> 00:46:32,860
Habemus totum fasciculum
Bissexti motu cogitationes,

1074
00:46:32,860 --> 00:46:36,500
quae USB machinulis ad Macs et
Pulvinar huc iterum Novi Portus.

1075
00:46:36,500 --> 00:46:40,080
Quod si tua ponte Mac
vos can vere temperare vestri computer

1076
00:46:40,080 --> 00:46:42,550
scripto software
quod via ultrarubrum trabes,

1077
00:46:42,550 --> 00:46:46,360
figuravit de quo sit tua sunt opera manuum hominum,
sine ulla quoque adtrectatione tua tincidunt.

1078
00:46:46,360 --> 00:46:49,135
Nos putavimus wed 'a velox participes
prospiciamus hoc puta.

1079
00:46:49,135 --> 00:46:51,428
>> [MUSIC PLAYING]

1080
00:46:51,428 --> 00:47:55,840

1081
00:47:55,840 --> 00:47:57,590
Sic habemus totum
fasciculum harum rerum,

1082
00:47:57,590 --> 00:48:01,040
etiam dicitur myo armillas
quem constitueris super brachium tuum

1083
00:48:01,040 --> 00:48:04,595
deinde rerum domina
orbis terrarum, et hoc virtutis.

1084
00:48:04,595 --> 00:48:06,471
>> [MUSIC PLAYING]

1085
00:48:06,471 --> 00:49:17,580

1086
00:49:17,580 --> 00:49:20,920
Vel etiam aliquid Google
Cardboard, quod est ad litteram, sicut,

1087
00:49:20,920 --> 00:49:24,841
consurge consurge induere posset cardboard buxum
faciem tuam volutpat interdum eam

1088
00:49:24,841 --> 00:49:27,590
ita ut nihil vobis posuit vitrum vestris
interdum vero circa oculos.

1089
00:49:27,590 --> 00:49:30,190
Et Cardboard est Google
at $ XX vel $ X satis vili.

1090
00:49:30,190 --> 00:49:32,230
Et parum lentium
qui leviter off trabea

1091
00:49:32,230 --> 00:49:35,900
tentorium ad imaginem tuam hominem
oculos tibi sensu profundum

1092
00:49:35,900 --> 00:49:39,550
ut etiam a 3D
environment in conspectu vestro.

1093
00:49:39,550 --> 00:49:42,927
Nos quoque aliquid Gear Samsung, quae
est magis carus version of this,

1094
00:49:42,927 --> 00:49:46,010
sed quod similiter potest labi in an
MASCULINUS phone dantes illusio

1095
00:49:46,010 --> 00:49:48,309
of-- aut experientiam
virtualis realitatem.

1096
00:49:48,309 --> 00:49:50,850
Nostra vero duo minuta,
Lorem putassemus a nobis internosci conantur facere.

1097
00:49:50,850 --> 00:49:55,250
Si possum project habet quod Colton
acuebat hic sumere,

1098
00:49:55,250 --> 00:49:58,442
permitte me praecedere, et projice
hic in magnus screen.

1099
00:49:58,442 --> 00:49:59,400
Let me occidere luminibusque distinxerit.

1100
00:49:59,400 --> 00:50:02,290
Col vis praecedere
et induere cultioribus cellam parumper

1101
00:50:02,290 --> 00:50:05,171
et venient super transeamus ad stationem
media scaena?

1102
00:50:05,171 --> 00:50:07,420
Et vultis project--
hoc est quod Colton videt.

1103
00:50:07,420 --> 00:50:10,560
>> Sed hic in Wi-FI
sed non ita olidus ad hanc fabricam

1104
00:50:10,560 --> 00:50:13,870
hoc est eximius cogens,
sed est litteram Colton

1105
00:50:13,870 --> 00:50:15,710
in hoc magicis futuristic loco.

1106
00:50:15,710 --> 00:50:16,796
Tantum videt una imago.

1107
00:50:16,796 --> 00:50:19,920
Vos vidistis et super oculum dextrum ejus:
quod his cerebrum suta cavatis simul

1108
00:50:19,920 --> 00:50:22,260
in a tres dimensiva
environment in faciem suam.

1109
00:50:22,260 --> 00:50:24,319
Hic mox sumpto menu bene hic.

1110
00:50:24,319 --> 00:50:27,360
Ita quoque tincidunt hac circumdatus ipse
Samsung cum a phone super eam ut '

1111
00:50:27,360 --> 00:50:29,080
wirelessly proiecta, uti nostri horrore visos.

1112
00:50:29,080 --> 00:50:30,349
Erant autem in Martem existimant?

1113
00:50:30,349 --> 00:50:31,140
Colton: ego ita censeo.

1114
00:50:31,140 --> 00:50:32,181
Im 'non certus [tacita].

1115
00:50:32,181 --> 00:50:34,250
[LAUGHTER]

1116
00:50:34,250 --> 00:50:36,374
>> DAVID Malan: Volvit sicco
Mars illa menus.

1117
00:50:36,374 --> 00:50:41,590
>> Colton: [tacita] nonnullus frigus
loca si reintrare volumus ad constituite

1118
00:50:41,590 --> 00:50:43,330
>> DAVID Malan: Quo vis ire?

1119
00:50:43,330 --> 00:50:45,837
>> Colton: [tacita]

1120
00:50:45,837 --> 00:50:48,170
DAVID Malan: et lets videre
ubi Colton Deduxerit nunc.

1121
00:50:48,170 --> 00:50:48,961
Colton: [tacita]

1122
00:50:48,961 --> 00:50:52,830

1123
00:50:52,830 --> 00:50:56,380
>> DAVID malan pus tot illic
pluribus locis te potes.

1124
00:50:56,380 --> 00:51:00,590
Illic 'FAPIs via qua vos can
Ludis interim aut scribere interactions quod

1125
00:51:00,590 --> 00:51:01,950
run tandem bibit.

1126
00:51:01,950 --> 00:51:03,908
Sic, vos vere iustus
scribens app mobile phone.

1127
00:51:03,908 --> 00:51:06,380
Sed gratias ad software
et graphics capacitatem naturae replet,

1128
00:51:06,380 --> 00:51:08,765
Colton nunc est in hoc
exigua casa rara fuit.

1129
00:51:08,765 --> 00:51:10,515
Et dubio periculo obiecissent
opprimendi nos,

1130
00:51:10,515 --> 00:51:13,330
Nam et ego Col perstiteris
dum in fine class hodie

1131
00:51:13,330 --> 00:51:14,300
si velis ascendere exultant lusibus.

1132
00:51:14,300 --> 00:51:16,350
Et reducam eos
revertar proxima septimana pariter.

1133
00:51:16,350 --> 00:51:18,420
Nec diutius, Ado
id est hodie.

1134
00:51:18,420 --> 00:51:21,990
Nos videre proxima septimana.

1135
00:51:21,990 --> 00:51:24,140
>> [Music - ragga geminorum "malus"]

1136
00:51:24,140 --> 00:55:23,146