1
00:00:00,000 --> 00:00:02,000
[Powered by Google Translate] [SQL]

2
00:00:02,000 --> 00:00:04,000
[CHRISTOPHERVM Bartholomeus] [Harvard University]

3
00:00:04,000 --> 00:00:06,000
[HOC EST CS50] [CS50 TV]

4
00:00:07,950 --> 00:00:11,620
Sic, programmers uti databases quasi tool congregem atque ordinare

5
00:00:11,620 --> 00:00:13,620
noster pertinax notitia intra tabulas.

6
00:00:13,620 --> 00:00:18,960
Unde non levis repono vestri notitia est ut medians ferreus coegi,

7
00:00:18,960 --> 00:00:22,940
movet etiam per eu, integro data est.

8
00:00:22,940 --> 00:00:29,530
Et, sicut programmers noster progressio utilitas databases pro missionibus talis ut thesaurizantes

9
00:00:29,530 --> 00:00:32,890
user notitia ex textus vultus, suspiciens inventarium,

10
00:00:32,890 --> 00:00:36,210
aut adaequationis information about quid sites expandent.

11
00:00:37,150 --> 00:00:40,070
Sed quomodo nos sumus, esse mutuam cum nostris database,

12
00:00:40,070 --> 00:00:43,150
quid aut legere solent, repones, tellus,

13
00:00:43,150 --> 00:00:46,070
et update nostra notitia, intra haec database mensis?

14
00:00:47,280 --> 00:00:49,700
Est ergo dicendum, quod specialis ratio datorum verbis utamur

15
00:00:49,700 --> 00:00:53,400
quae interacts directe cum nostris database tabulis.

16
00:00:53,400 --> 00:00:56,740
Quod suus 'est nomen exstructa Query Language,

17
00:00:56,740 --> 00:00:58,740
[Exstructa Query Language]

18
00:00:58,740 --> 00:01:00,740
aut quid ego referri ad sicut SQL.

19
00:01:00,740 --> 00:01:05,100
>> Nunc, [Se-QueL], aut SQL, non est programming lingua,

20
00:01:05,100 --> 00:01:08,580
sed praestat illud signum mandati sermone

21
00:01:08,580 --> 00:01:13,520
ut retrieve et manipulare notitia ex varietate database procuratio ratio.

22
00:01:13,520 --> 00:01:17,630
, Ad hoc enim CS50, puteus 'ire, supra quattuor basic iubet:

23
00:01:17,630 --> 00:01:21,210
selectos inserere, update, et delete.

24
00:01:21,210 --> 00:01:26,230
Praeterea, puteus 'utilitas a database web interface vocavit phpMyAdmin,

25
00:01:26,230 --> 00:01:29,890
quae installed in INSTRUMENTUM scribere nostri SQL diceres.

26
00:01:30,830 --> 00:01:33,050
Ut rutrum meminisse iubet,

27
00:01:33,050 --> 00:01:37,080
Ive 'quidam attulit cupcakes in armarium, assistere cum nostris scenarios.

28
00:01:39,650 --> 00:01:42,210
Dicere vos habere cupcake scriptor database,

29
00:01:42,210 --> 00:01:44,490
ubi vos repono omnes notitia super vestri cupcakes.

30
00:01:44,490 --> 00:01:48,220
Nunc, databases continere possit multis mensis

31
00:01:48,220 --> 00:01:50,950
columnas autem multas mensas possunt.

32
00:01:50,950 --> 00:01:57,020
Inside nostrum cupcake scriptor database, habemus mensam vocavit cupcake_cupboard.

33
00:01:57,020 --> 00:02:00,500
Haec mensa adhiberi poterit congregem omnes information about cupcakes

34
00:02:00,500 --> 00:02:02,990
quæ sunt, bene, in vestris armarium.

35
00:02:02,990 --> 00:02:07,770
Columnas intus sunt, mensa tua repraesentant attributa a cupcake.

36
00:02:07,770 --> 00:02:14,560
Pro exemplo, cupcake_cupboard scriptor columnae sunt

37
00:02:14,560 --> 00:02:15,920
Crustulam ID, CakeType, CakeColor, et CakeIsNice.

38
00:02:15,920 --> 00:02:23,040
Hoc boolean-typed column est adsuesco assuesco decerno si placentam delicatus vel non nice quod.

39
00:02:23,040 --> 00:02:26,560
Lorem scripta delectus Sumamus dictum.

40
00:02:26,560 --> 00:02:32,160
Select dicta sunt inducta ad retrieve notitia de particulari database mensam.

41
00:02:32,160 --> 00:02:34,890
In sem est, omnia scire

42
00:02:34,890 --> 00:02:39,080
de omnibus cupcakes, quae sunt in armarium.

43
00:02:39,080 --> 00:02:48,670
Syntaxum hoc facere est "Select" spatium stella, aut *, tractus ex spatio nostra tabula

44
00:02:48,670 --> 00:02:52,050
quae est cupcake_cupboard.

45
00:02:52,050 --> 00:02:54,640
Eamus forth et exsequendo.

46
00:02:56,670 --> 00:03:00,140
>> Sicut et nos videre possunt, isti sunt omnes cupcakes in nostra armarium.

47
00:03:00,140 --> 00:03:05,110
Suus 'maximus ut nota ut *, aut asterisco, est silvestre card character

48
00:03:05,110 --> 00:03:08,830
quod denotat collectio omnium columnarum, alicuius mensam.

49
00:03:08,830 --> 00:03:13,650
Normally, nos can obvius specifica column aut columnarum

50
00:03:13,650 --> 00:03:16,950
a repositoque * cum vera columpna nomen.

51
00:03:16,950 --> 00:03:21,220
Pluribus agminibus velit, non omnia possimus consequi

52
00:03:21,220 --> 00:03:25,620
per scripturam agmen nomina definientia singularum columnarum per distingue.

53
00:03:25,620 --> 00:03:28,620
Pro exemplo, lets tantum recipiendum CakeId et CakeType in cupcake_cupboard mensam.

54
00:03:28,620 --> 00:03:38,370
Syntaxum hoc facere est: Virgil spatium CakeID distingue

55
00:03:38,370 --> 00:03:44,370
CakeType spatium ab mensam nostram cupcake_cupboard.

56
00:03:44,370 --> 00:03:46,370
Eamus et praemittat hoc facere.

57
00:03:49,340 --> 00:03:52,670
Et hic, nunc nos solum habent duas columnas nos specificatur

58
00:03:52,670 --> 00:03:54,670
pro singulis cupcake in nostra armarium.

59
00:03:54,670 --> 00:03:57,710
Possumus etiam colabit nostri query results specificando

60
00:03:57,710 --> 00:04:00,910
in "Ubi" clausula mox mensam nomen.

61
00:04:02,000 --> 00:04:05,410
Quin etiam apparet in armario cupcake

62
00:04:05,410 --> 00:04:08,660
id est, bene, non sic nice vultus.

63
00:04:08,660 --> 00:04:13,950
Lets instar sicco omnes cupcakes in nostra armarium, qui dicuntur, bene, non sic nice aspiciens

64
00:04:13,950 --> 00:04:16,110
usura "Ubi" clausula.

65
00:04:16,110 --> 00:04:26,390
Syntaxum hoc facere est: Virgil spatium spatio EX spatium cupcake_cupboard

66
00:04:26,390 --> 00:04:34,080
spatium UBI spatium nostri conditionalis columna, in hoc casu CakeIsNice =,

67
00:04:34,080 --> 00:04:36,900
et boolean valorem Falsa.

68
00:04:36,900 --> 00:04:42,750
Illud notandum quod si fidibus utuntur, oportet unum claudunt citat.

69
00:04:42,750 --> 00:04:49,620
Hoc est verum pro omnibus Funiculos in SQL, vel in SQL database terminis, variant characters

70
00:04:49,620 --> 00:04:51,620
notus ut Varchar datatype.

71
00:04:51,620 --> 00:04:57,660
Hic utemur vera aut falsa sit, non soluto pretio boolean.

72
00:04:59,120 --> 00:05:00,660
Et facere ante eamus praecipit.

73
00:05:00,660 --> 00:05:05,340
>> Ecce eget fit nobis I

74
00:05:05,340 --> 00:05:07,920
non ita nice cupcake in nostra armarium.

75
00:05:09,620 --> 00:05:11,460
Deinde adiiciunt quod erant 'iens ut scriberem.

76
00:05:11,460 --> 00:05:15,560
Insert dicta sunt inducta ad inserere seu addere

77
00:05:15,560 --> 00:05:17,770
additional rows of notitia in vestri database mensam.

78
00:05:17,770 --> 00:05:23,160
Revisendae nostra missione, lets formam sumpseris ut weve iustorum torris novum cupcake.

79
00:05:25,910 --> 00:05:30,080
Cum nos valde sunt organized cupcake comestores, erant 'habiturus inserere hoc novum cupcake

80
00:05:30,080 --> 00:05:32,330
in nostra cupcake_cupboard mensam.

81
00:05:32,330 --> 00:05:40,690
Syntaxum facere huius est ista: Insert spatio in spatium nostra tabula

82
00:05:40,690 --> 00:05:46,830
cupcake_cupboard, tractus (,

83
00:05:46,830 --> 00:05:51,060
Et haec determinentur columnas nomina definitur sanctificat

84
00:05:51,060 --> 00:05:59,790
CakeType distingue CakeColor distingue CakeIsNice) spatio.

85
00:05:59,790 --> 00:06:06,540
Consequenter spatium valores verbum scribere (hic

86
00:06:06,540 --> 00:06:12,170
nos introire valor pro singularum columnarum respective, etiam definitur distingue.

87
00:06:12,170 --> 00:06:17,830
Single auctoritate, quia omnes sunt Varchar valores puteus 'circumdedamus eos in simplicibus auctoritates,

88
00:06:17,830 --> 00:06:26,780
PEANUT BUTURUM 'distingue' LUX BRUNUS 'distingue Vera.

89
00:06:26,780 --> 00:06:30,480
Iam, suus 'maximus dare cuique row a unique numerus ad recognoscendas se.

90
00:06:30,480 --> 00:06:33,660
Autoincrementing columna providet hoc sicut

91
00:06:33,660 --> 00:06:37,410
 "Minime duo eadem IDs nusquam aliquid existere potest in hac tabula."

92
00:06:37,410 --> 00:06:39,480
Et facere ante eamus.

93
00:06:39,480 --> 00:06:45,380
Ibi ire debemus, omnes organisatum.

94
00:06:49,720 --> 00:06:52,100
>> Postero SQL hoc quod dicit quod nos mos scribere est update constitutionis est.

95
00:06:52,100 --> 00:06:55,650
Update constitutionis adhiberi potest modificare notitia intra column

96
00:06:55,650 --> 00:06:58,440
pro quolibet existentium remigare intus vestri database mensam.

97
00:06:59,670 --> 00:07:03,420
Prius in nostra missionem, usura a selectis constitutionis, nos identificatur a cupcake

98
00:07:03,420 --> 00:07:08,300
intra nostram cupcake_cupboard mensam domini cuius CakeIsNice valorem erat falsum.

99
00:07:08,300 --> 00:07:12,050
Lets formam sumpseris ut dum nostri peanut butyrum cupcake erat in clibano,

100
00:07:12,050 --> 00:07:15,790
fecimus non-sic-nice quod cupcake valde nice.

101
00:07:18,020 --> 00:07:22,240
Dimissus tam praecipuae organisatum, optamus cupcake reflectere hoc valore

102
00:07:22,240 --> 00:07:24,240
in nostra cupcake_cupboard mensam.

103
00:07:24,240 --> 00:07:28,710
Ergo, lets update nostri socolate cupcake in database reflectere hoc.

104
00:07:28,710 --> 00:07:39,720
Syntaxum est: UPDATE spatium nostra tabula cupcake_cupboard, spatium INDUTILIS spatium

105
00:07:39,720 --> 00:07:44,240
columnae mutari volumus, CakeIsNice =.

106
00:07:44,240 --> 00:07:49,210
Tunc hic nos collocare nostram novus valor Vera spatio.

107
00:07:49,210 --> 00:07:54,290
Sed quia omnes ordines nolo hoc valore update,

108
00:07:54,290 --> 00:07:57,400
nos volo ut suggero a "Ubi" clausula ut mos pinpoint nobis

109
00:07:57,400 --> 00:07:59,830
ad exactam row volumus modify.

110
00:07:59,830 --> 00:08:03,690
In hoc cognoscimus quoniam unus cupcake

111
00:08:03,690 --> 00:08:06,670
quod habet CakeIsNice valorem Falsa.

112
00:08:06,670 --> 00:08:11,030
Praeterea, nos quoque curare ut sumus adaequationis ad rectam row

113
00:08:11,030 --> 00:08:13,030
et per "et" dignoscitur.

114
00:08:14,340 --> 00:08:17,270
Nos utor "Et" clausulam colabit nostri query ulterius.

115
00:08:17,270 --> 00:08:20,380
In hoc casu, quia scimus quod cupcake est socolate,

116
00:08:20,380 --> 00:08:23,160
utemur hoc CakeType column.

117
00:08:23,160 --> 00:08:31,500
UBI spatium nostri conditionalis column spatium CakeIsNice spatium =, falsis

118
00:08:31,500 --> 00:08:38,330
et spatio CakeType = 'Chocolate.'

119
00:08:38,330 --> 00:08:41,880
Ideo ipsa dimissa omnibus simul, hoc update constitutionis dicit

120
00:08:41,880 --> 00:08:44,670
invenire omnes cupcakes in nostra cupcake armario inclusus,

121
00:08:44,670 --> 00:08:50,520
et si est ibi cupcake cuius column CakeIsNice continet valor Falsa

122
00:08:50,520 --> 00:08:54,130
et CakeType continet valor Chocolate,

123
00:08:54,130 --> 00:08:58,240
nos volo ut update specifica ordines CakeIsNice pendo ut Vera.

124
00:08:58,240 --> 00:09:01,140
Ut ante eamus et facere illud.

125
00:09:03,860 --> 00:09:05,860
Et nunc, erant 'organized.

126
00:09:06,650 --> 00:09:09,220
>> Haec omnia loquuntur de cupcakes me fecit aliquantulus esurientibus.

127
00:09:09,220 --> 00:09:11,360
Qui adiuvet me puto.

128
00:09:11,360 --> 00:09:17,670
Sed si ego actu manducare hoc cupcake, ne ego saltem etiam removere existentiam suam,

129
00:09:17,670 --> 00:09:19,670
 a nostris cupcake_cupboard mensam.

130
00:09:20,650 --> 00:09:22,590
Ad hoc utemur "Delete" dicuntur.

131
00:09:22,590 --> 00:09:27,400
The "Delete" constitutionis potest inducta ad removendum vel omnes vel aliquos ordines de mensa.

132
00:09:27,400 --> 00:09:29,920
Determinatum ordinem velis tollere de tabula

133
00:09:29,920 --> 00:09:34,360
tunc oportet tibi suggero a "Ubi" clausula, sic specificantis columna

134
00:09:34,360 --> 00:09:37,660
ordinem proprium velle debeant auferri.

135
00:09:37,660 --> 00:09:47,370
Haec est syntax: ERADO spatium EX spatium nostra tabula cupcake_cupboard, spatio.

136
00:09:47,370 --> 00:09:51,760
Nunc, in isto puncto, quandocumque hoc sunt et longe in vestri delete constitutionis

137
00:09:51,760 --> 00:09:54,240
vis diligentius.

138
00:09:54,240 --> 00:09:59,970
Nam si aliqua vis currere lata sine hoc quod quaeris, "ubi" particula

139
00:09:59,970 --> 00:10:04,500
Ego totum perderet notitia in hoc cupcake_cupboard mensam,

140
00:10:04,500 --> 00:10:09,590
Sed jam scio me IDs adipiscing unica sunt utar

141
00:10:09,590 --> 00:10:12,410
Rubrum holoserica placentam ID pro mea "Ubi" clausula.

142
00:10:14,550 --> 00:10:20,670
UBI spatium agminis nostri, CakeID = I.

143
00:10:20,670 --> 00:10:25,010
Quia non opus est integrum pretium accumsan una circumdare.

144
00:10:25,010 --> 00:10:27,020
Sic, lets funguntur constitutionis est.

145
00:10:33,560 --> 00:10:35,990
Bene autem, quod diximus esse deletas cupcake

146
00:10:35,990 --> 00:10:40,360
a nostris cupcake_cupboard mensa solum habent unum sinistram:

147
00:10:41,680 --> 00:10:43,680
Faceret illud evanescunt.

148
00:10:43,680 --> 00:10:46,990
Im 'Christopher Bartholomei. Hoc est CS50.