Shadowhelix:Datenbank/Vorschläge: Unterschied zwischen den Versionen

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
(eingefügte contributors, weblinks entfernt)
Zeile 5: Zeile 5:
INSERT INTO contributors(forename_first) VALUES('Liam.C');
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('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('Thomas', 'Evan');
INSERT INTO contributors(surname, forename_first) VALUES('DeChellis', 'Garret');
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('Fiorentini', 'Igor');
INSERT INTO contributors(surname, forename_first) VALUES('DuQue', 'Joel');
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('Birdsong', 'Keith');
INSERT INTO contributors(surname, forename_first) VALUES('Bishop', 'Ken');
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('Peroni', 'Mauro');
INSERT INTO contributors(surname, forename_first) VALUES('Petrov', 'Miroslav');
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('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('Manold', 'Alyssa', 'Ann');
Zeile 30: Zeile 23:
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Kukalis', 'Romas', 'Brandt');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Kukalis', 'Romas', 'Brandt');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Hao', 'Tan', 'Jia');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Hao', 'Tan', 'Jia');
</pre>
<pre>
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;
</pre>
</pre>



Version vom 15. Februar 2016, 13:59 Uhr

Shadowhelix:Datenbank

Erweiterung

INSERT INTO contributors(forename_first) VALUES('Liam.C');

INSERT INTO contributors(surname, forename_first) VALUES('Giancola', 'Donato');
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('Fiorentini', 'Igor');
INSERT INTO contributors(surname, forename_first) VALUES('DuQue', 'Joel');
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('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, 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');

Korrektur

Dopplungen?

  • 3077 - Joshua Howell
  • 7157 - Joshua Rowell
  • 7468 - Larry Almore
  • 8047 - Larry Elmore