Results 1 to 10 of 10
Thread: sql
Hybrid View
-
27th May 2011 15:52 #1
sql
2 : students grades.
students - , , , ( )
grades - id ( ), id na ( ), , , .
, , . . ?
grades students. , , .
, .Last edited by HardDrive; 27th May 2011 at 22:27.
Config: Ryzen 3700x / Gigabyte x570 Gaming X / RX480 Strix 1400@2250 / 2x8gb Corsair Vengeance / Seagate Barracuda 1Tb + 256gb OCZ Trion / SuperFlower Leadex II Gold 750w / BeQuiet B801 / LG 23MA53 + Philips 170c / Logitech G502 / CM QuickFire TK
Acer Predator G9-593 I7 7700HQ + GTX1070
-
27th May 2011 16:28 #2Registered User
Join Date: May:2011
Location: BG
Posts: 7
students id grades. ?
, .
P.S. , . Stored procedure ?
-
27th May 2011 16:52 #3
.
, , .
Stored Procedure e , , .
Code:alter table grades DROP FOREIGN KEY rel2; update students s, grades g set g.stud_id='1100', s.fnum='1100', s.name='ppp', s.mname='zzz', s.fname='gogo' where s.fnum='33' and g.stud_id='33'; alter table grades add constraint rel2 foreign key (stud_id) references Students(fnum);
Config: Ryzen 3700x / Gigabyte x570 Gaming X / RX480 Strix 1400@2250 / 2x8gb Corsair Vengeance / Seagate Barracuda 1Tb + 256gb OCZ Trion / SuperFlower Leadex II Gold 750w / BeQuiet B801 / LG 23MA53 + Philips 170c / Logitech G502 / CM QuickFire TK
Acer Predator G9-593 I7 7700HQ + GTX1070
-
27th May 2011 17:14 #4Registered User
Join Date: May:2011
Location: BG
Posts: 7
, - , .
. .
-
27th May 2011 17:19 #5
, , .
Config: Ryzen 3700x / Gigabyte x570 Gaming X / RX480 Strix 1400@2250 / 2x8gb Corsair Vengeance / Seagate Barracuda 1Tb + 256gb OCZ Trion / SuperFlower Leadex II Gold 750w / BeQuiet B801 / LG 23MA53 + Philips 170c / Logitech G502 / CM QuickFire TK
Acer Predator G9-593 I7 7700HQ + GTX1070
-
27th May 2011 17:25 #6Registered User
Join Date: Feb:2006
Location: Plovdiv
Posts: 392
-
27th May 2011 21:17 #7
1. "" " " - . , .
2. , . , , . , , primary key . . alter . , , , constraint- ? .
3. PK FK , . - , - , - auto increment .
4. . SQL . - .
5. , ? , .
6. MySQL :
http://dev.mysql.com/doc/refman/5.1/...nstraints.html
ON UPDATE CASCADE.''? * *
- !
...
-
27th May 2011 23:49 #8
HardDrive, The daily wtf ... vbTheKing. . , .. . , / . , . .
Thre are 10 kinds of people in this world - people who know binary, and those who don't.
-, .
-
28th May 2011 08:04 #9
><. "" , . !
Config: Ryzen 3700x / Gigabyte x570 Gaming X / RX480 Strix 1400@2250 / 2x8gb Corsair Vengeance / Seagate Barracuda 1Tb + 256gb OCZ Trion / SuperFlower Leadex II Gold 750w / BeQuiet B801 / LG 23MA53 + Philips 170c / Logitech G502 / CM QuickFire TK
Acer Predator G9-593 I7 7700HQ + GTX1070
-
28th May 2011 19:38 #10Registered User
Join Date: Jul:2010
Location: Sofia
Posts: 142
ON UPDATE CASCADE( -, ON DELETE CASCADE). 3 - students ( ), grades () students.
PK ( sequence auto increment). Primary key-a , update , .




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in