Shadowhelix:Datenbank/Vorschläge: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Loki (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „Shadowhelix:Datenbank ==Erweiterung== <pre> INSERT INTO contributors(forename_first) VALUES('Liam.C'); INSERT INTO contributors(surname, forename_first) …“) |
Loki (Diskussion | Beiträge) (Korrektur: ID Aaron Riley - Zahlendreher 5167 statt 5176) |
||
| Zeile 33: | Zeile 33: | ||
<pre> | <pre> | ||
UPDATE contributors_weblink SET url = 'http://www.aaronjriley.com/' WHERE id_contributor= | UPDATE contributors_weblink SET url = 'http://www.aaronjriley.com/' WHERE id_contributor=5167; | ||
UPDATE contributors_weblink SET url = 'http://rilez75.deviantart.com/' WHERE id_contributor= | UPDATE contributors_weblink SET url = 'http://rilez75.deviantart.com/' WHERE id_contributor=5167; | ||
UPDATE contributors_weblink SET url = 'http://www.alanpollack.com/' WHERE id_contributor=4080; | UPDATE contributors_weblink SET url = 'http://www.alanpollack.com/' WHERE id_contributor=4080; | ||
UPDATE contributors_weblink SET url = 'http://alexdrummo.blogspot.de/' WHERE id_contributor=3022; | UPDATE contributors_weblink SET url = 'http://alexdrummo.blogspot.de/' WHERE id_contributor=3022; | ||
</pre> | </pre> | ||
Version vom 11. Februar 2016, 18:21 Uhr
Erweiterung
INSERT INTO contributors(forename_first) VALUES('Liam.C');
INSERT INTO contributors(surname, forename_first) VALUES('Newman', 'Ben');
INSERT INTO contributors(surname, forename_first) VALUES('Smit', 'David');
INSERT INTO contributors(surname, forename_first) VALUES('Giancola', 'Donato');
INSERT INTO contributors(surname, forename_first) VALUES('Su', 'Emily');
INSERT INTO contributors(surname, forename_first) VALUES('Thomas', 'Evan');
INSERT INTO contributors(surname, forename_first) VALUES('DeChellis', 'Garret');
INSERT INTO contributors(surname, forename_first) VALUES('Whitehall', 'Gino');
INSERT INTO contributors(surname, forename_first) VALUES('Fiorentini', 'Igor');
INSERT INTO contributors(surname, forename_first) VALUES('DuQue', 'Joel');
INSERT INTO contributors(surname, forename_first) VALUES('Rudkiewicz', 'Kaija');
INSERT INTO contributors(surname, forename_first) VALUES('Birdsong', 'Keith');
INSERT INTO contributors(surname, forename_first) VALUES('Bishop', 'Ken');
INSERT INTO contributors(surname, forename_first) VALUES('Sintes', 'Marc');
INSERT INTO contributors(surname, forename_first) VALUES('Peroni', 'Mauro');
INSERT INTO contributors(surname, forename_first) VALUES('Petrov', 'Miroslav');
INSERT INTO contributors(surname, forename_first) VALUES('McMurchy', 'Sean');
INSERT INTO contributors(surname, forename_first) VALUES('Waern', 'Theodore');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Manold', 'Alyssa', 'Ann');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Calabria', 'Anthony', 'John');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Poole', 'Derek', 'G.');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Thiesen', 'James', 'Joseph');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Cuba', 'Laura', 'Diaz');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Kukalis', 'Romas', 'Brandt');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Hao', 'Tan', 'Jia');
UPDATE contributors_weblink SET url = 'http://www.aaronjriley.com/' WHERE id_contributor=5167; UPDATE contributors_weblink SET url = 'http://rilez75.deviantart.com/' WHERE id_contributor=5167; UPDATE contributors_weblink SET url = 'http://www.alanpollack.com/' WHERE id_contributor=4080; UPDATE contributors_weblink SET url = 'http://alexdrummo.blogspot.de/' WHERE id_contributor=3022;